Connecting to an existing database in a ASP.NET MVC4 Web API project

Question

I'm building an web api using ASP.NET web api framework. I have seen a few tutorials on how to get started but I haven't found to use an existing SQL Server database. I have the database up and running also added the data connection to the database explorer in VS but I don't know how to connect the database to my project so I can start using it as my repository. How can I do that?

Dmitry S. · Accepted Answer · 2012-12-04 22:27:47Z

1

Put the following in your application web.config file and replace "yourConnectionString" with the actual connection string.

<configuration>
       <connectionStrings>
           <add name="DbConnection" connectionString="yourConnectionString" />
       </connectionStrings>
</configuration>

In the code use System.Configuration.ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString to get its value. You might need to reference the "System.Configuration" assembly in your project.

answered Dec 4, 2012 at 22:27

Dmitry S.

8,5532 gold badges41 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Connecting to an existing database in a ASP.NET MVC4 Web API project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related