Linq to SQL - What am i missing?

Question

I'm a complete newbie to LINQ, so please bare with my stupid questions.

Using Visual Studio I've created a DBML file, and added a table to it from a local database. This created a data context called UserDataContext. In my ASPX page I can create an instance of the data context using:

UserDataContext db1 = new UserDataContext();

However when I try to query against the table I get to:

var query = from o in db1.

and from there I can't see the table.... the dbml shows the table has public access.

Any ideas what I've missed?

var query = from o in db1 // this will not compile. you forgot "select" part — zerkms
– zerkms, Commented Jul 18, 2010 at 13:29
If you post code or XML, please highlight those lines in the text editor and click on the "code" button (101 010) on the editor toolbar to nicely format and syntax highlight it! — marc_s
– marc_s, Commented Jul 18, 2010 at 13:43
Did you ever compile the project before trying to write the Linq-to-SQL query? In order for intellisense etc. to work, I believe you need to at least compile/build your project once — marc_s
– marc_s, Commented Jul 18, 2010 at 13:44
Would it be reasonable to assume you're waiting for the intellisense to kick in and that's what you're not seeing? — Murph
– Murph, Commented Jul 18, 2010 at 15:28

Spooks · Accepted Answer · 2010-07-19 16:48:38Z

1

You need to select it afterwards, so with var query = from o in db1 would be

var query = from o in db1 select o

answered Jul 19, 2010 at 16:48

Spooks

7,20713 gold badges51 silver badges68 bronze badges

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

1 Comment

fearofawhackplanet Over a year ago

Don't know why this got upvoted since it's both wrong and not relevant to the question.

Gregory Kurts · Accepted Answer · 2010-07-19 16:52:14Z

Do you have using System.Linq; at the top of your code file? If you don't intellisense won't pick up for LINQ.

John Saunders · Accepted Answer · 2010-07-18 23:26:17Z

0

UserDataContext db1 = new UserDataContext(); var query = from o in db1 where o.fieldName = "abc" select p;

edited Jul 18, 2010 at 23:26

John Saunders

162k26 gold badges252 silver badges403 bronze badges

answered Jul 18, 2010 at 23:21

RedPanda

1357 bronze badges

1 Comment

John Saunders Over a year ago

@godz: to format your question, select it in the editor and press Control-K.

msarchet · Accepted Answer · 2010-07-19 16:52:34Z

I think he's asking more of why he can't see the table in the query

Have you built your solution since you created the Linq to SQL Models, if you haven't done this they won't show up.

p.campbell · Accepted Answer · 2010-07-19 16:56:02Z

Ensure your class is in the same namespace as your .dbml file. If your .dbml is in a subdirectory, it'll inherit that subdirectory as part of the namespace of the .dbml.

Glorfindel · Accepted Answer · 2023-02-03 12:34:15Z

If you want to query all tables in the database, or all columns in a table, I think you'll find this article useful.

Also, as zerkms pointed out in a comment, a LINQ query requires a select statement. It might help if you check out the desugared form of the LINQ query - it certainly helped me in avoiding these kinds of mistakes.

Collectives™ on Stack Overflow

Linq to SQL - What am i missing?

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Related