Connect to SQL server using Linq, asp.net

Question

I`m creating a website using asp.net, and I need to use a local SQL server (using Microsoft SQL server). And I have created database and tables in it using the MS SQL Server Management Studio.

Now I successfully connect to the database and do some simple add/query using the following commands:

string connectionString = "data source=ABCD\\SQLEXPRESS;initial catalog=PMD;Trusted_Connection=yes;"; string sqlQuery = "INSERT INTO PMD (username, userID, userAddress)"; sqlQuery += " VALUES (@user, id, add)"; SqlConnection dataConnection = new SqlConnection(connectionString); SqlCommand dataCommand = new SqlCommand(sqlQuery, dataConnection); dataCommand.Parameters.AddWithValue("user", USER.Value); dataCommand.Parameters.AddWithValue("id", ID.Value); dataCommand.Parameters.AddWithValue("add", ADDRESS.Text); dataConnection.Open(); dataCommand.ExecuteNonQuery(); dataConnection.Close();

The command above can add one column to the table, with values stated. The query is done in a similar way. Compared with Linq, this is not very concise.

So I was wondering how can I change the code so I can use Linq.

The biggest question for me now is how to connect to the base. I already know all the syntax of Linq.

eg: var query=from c in db.username where c.Contain(“Micheal”) select c (or maybe db.PMD.username)

How can I get the db to link with ABCD/SQLEXPRESS, table PMD?

@Daniel I dont know what Im using right now. I searched "how to connect to sql, asp.net" and find the code and it`s working. Now I would like to change it so I can use linq to sql. — user1739292
– user1739292, Commented Oct 16, 2012 at 15:30
@DanielA.White OP is using neither. The above code is basic ADO.NET. — Dennis Traub
– Dennis Traub, Commented Oct 16, 2012 at 15:31

Dennis Traub · Accepted Answer · 2012-10-16 15:38:33Z

1

First you need an Object/Relational Mapper (O/RM). You can't just put LINQ on top of your old ADO.NET code.

Microsoft provides two: Linq2SQL and Entity Framework.

Linq2SQL has been discontinued. If I had to choose between the two, I'd go with Entity Framework.

Here you can find an introduction: http://www.asp.net/entity-framework

edited Oct 16, 2012 at 15:38

answered Oct 16, 2012 at 15:33

Dennis Traub

51.9k7 gold badges100 silver badges113 bronze badges

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

7 Comments

user1739292 Over a year ago

Hi Dennis, Thanks for the reply. So I cannot just add some code to it and use Linq to SQL?

Dennis Traub Over a year ago

No, you can't. You need a LINQ provider that translates LINQ queries to SQL. This is where Entity Framework comes in.

Gromer Over a year ago

@user1739292, well, setting up an Entity Framework context from a database takes all of 5 minutes, so don't think it will take forever. It's pretty quick.

user1739292 Over a year ago

thanks for the above reply. I`m using Webmatrix to develop the website, not VS. so it is the same process?

Dennis Traub Over a year ago

Have a look at the first answer to this question: stackoverflow.com/questions/10626492/…

|

Community · Accepted Answer · 2017-05-23 11:43:14Z

0

For example, install Entity Framework, then connect to sql server with entity framework

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Oct 16, 2012 at 15:36

Gábor Plesz

1,2231 gold badge18 silver badges29 bronze badges

Collectives™ on Stack Overflow

Connect to SQL server using Linq, asp.net

2 Answers 2

7 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Linked

Related