Database connection and querying in ASP.NET

Question

Okay, so after about an hour of searching through the web, I'm still having issues trying to create a local DB connection in ASP.net.

I need to create a connection to a local database file, and then simply loop through each record in a table. I'm not sure which file extension to use here (.aspx, .vbhtml, .cshtml?)

This is what I currently have from this W3school tutorial,

' Create local connection to DB file
@{
var db = Database.Open("Properties.mdf"); 
var query = db.Query("SELECT * FROM Properties"); 
}

    <div id="pagewrap">

        ' Loop through records
        @foreach(var row in query)
        {

        <p>@row.StreetAddress</p> 
        <p>@row.City</p> 
        <p>@row.State</p> 

        }

    </div>

I'm currently getting a Connection string "Properties.mdf" was not found. error when running the above code. Any help is greatly appreciated.

Is Properties.mdf in your app_data folder?

Tim
– Tim

2014-05-12 16:45:23 +00:00
Commented May 12, 2014 at 16:45 — Tim
– Tim, Commented May 12, 2014 at 16:45

Tarec · Accepted Answer · 2014-05-12 16:44:18Z

1

That is because "Properties.mdf" is not a connection string. The mdf file cannot be opened just like this on its own - it needs a proper sql server database service. Exemplary connection string could look like this

var db = Database.Open("Server=.\SQLExpress;AttachDbFilename=Properties.mdf;Database=mydatabase;Trusted_Connection=Yes");

Although you need to have sql server installed (in this case your sql server instance would be called SQLExpress). and the connection string highly depends on what version of SQL Server you want to connect to.

Please refer to MSDN article.

answered May 12, 2014 at 16:44

Tarec

3,2644 gold badges34 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Database connection and querying in ASP.NET

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