How to add existing SQL Server database to app_data folder of asp.net MVC project

Question

I have an existing database in SQL Server. I am trying to create an asp.net mvc project around this db.

For this purpose I need to add the db to app_data folder of asp.net MVC project

How do I achieve this?

Note:

The SQL Server is in another system and I do not have rights to install SQL Server Express on my machine as well :(

Darin Dimitrov · Accepted Answer · 2010-03-22 13:16:38Z

4

You don't need to add app_data directory or install SQL Express on your machine. All you need is a connection string allowing you to connect to the remote database.

Data Source=NameOfDbServer;Database=DatabaseName;User ID=User;Password=PWD;Trusted_Connection=False

Once you have the connection string you can start querying the database. The way you do this will depend primary on the technology you would like to use: NHibernate, LINQ to SQL, LINQ To Entities, plain old ADO.NET, ...

answered Mar 22, 2010 at 13:16

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

balalakshmi Over a year ago

do I need to add the connection string in web.config or any other file?

Darin Dimitrov Over a year ago

Externalizing the connection string in the connectionStrings section of the web.config is a good idea.

Collectives™ on Stack Overflow

How to add existing SQL Server database to app_data folder of asp.net MVC project

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related