Connect to Database with Connection String to use LINQ

Question

I have a connection string and I want to use LINQ to query a remote database. In the Microsoft example they use the DataContext class. However the DataContext does not appear in Intellisense. It says that it uses 'System.Data.Linq` but I am not seeing that either. http://msdn.microsoft.com/en-us/library/bb350721(v=vs.110).aspx

Is there a Hello World example for using a connection string and LINQ?

public void SimpleQuery()
{
    var connectionString = @"Server=10.1.10.1;database=Mydatabase;uid=myusername;password=mypassword;";
    DataContext dc = new DataContext(connectionString);

    var q =
        from n in dc.table
        select n;

    Console.WriteLine(n);
}

Have you added a reference to the System.Data.Linq assembly? — Rick Liddle
– Rick Liddle, Commented Jul 30, 2014 at 17:32

Selman Genç · Accepted Answer · 2014-07-30 17:45:01Z

5

Well, that is not how it works or at least it is not that simple.

In order to be able to run linq queries against your DB, first you need to map your db tables to dot net classes.

You can do that in various ways, for example you can use Linq to Sql, or Entity framework.

For EF, you need to decide which EF approach you are going to use (Model First,Code First etc.) Then you should configure your settings and create your db context.Take a look at Entity Framework documentation for more details...

edited Jul 30, 2014 at 17:45

answered Jul 30, 2014 at 17:33

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

Collectives™ on Stack Overflow

Connect to Database with Connection String to use LINQ

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related