Breaking News: Grepper is joining You.com. Read the official announcement!

how to connect db in asp.net

Purple Team answered on February 7, 2022 Popularity 9/10 Helpfulness 2/10

answer how to connect db in asp.net

how to connect db in asp.net

Comment

@{
var db = Database.Open("SmallBakery"); 
var selectQueryString = "SELECT * FROM Product ORDER BY Name"; 
}

@foreach(var row in db.Query(selectQueryString))
{
<tr> 
<td>@row.Id</td> 
<td>@row.Name</td> 
<td>@row.Description</td> 
<td align="right">@row.Price</td> 
</tr> 
}


The Database.Open(name) method will connect to a database in two steps:

First, it searches the application's App_Data folder for a database that matches the name parameter without the file-name extension.

If no file is found, it looks for a "connection string" in the application's Web.config file.

(A connection string contains information about how to connect to a database. It can include a file path, or the name of an SQL database, with full user name and password)

This two-step search makes it possible to test the application with a local database, and run the application on a web host using a connection string.

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: asp.net connect whatever

Link to this answer
Share Copy Link

Contributed on Feb 07 2022

Purple Team

0 Answers Avg Quality 2/10

how to connect db in asp.net

Contents

More Related Answers

how to connect db in asp.net

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.