inserting data using LINQ

Question

I have a Web Developer 2010 project with a DataSource called Names.  I have several tables but I started with just the Names table.  I created a LINQ to SQL object and dropped the names table into Names.dbml.  The resulting DataContext was put under my namespace of DataBaseClasses.

I set up a new datcontext call DB as follows.

DataBaseClasses.NamesDataContext db = new DataBaseClasses.NamesDataContext;

But I can't seem to reference any tables;

I tried:

var n = from n in db.Names

{

var Nam = LastName;

}

But I get an error saying db does not exist in the current context.

---

Harry T Ulmer

Answer 1

Hi Harry;

You are missing the ( and ) at the end of this statement.

DataBaseClasses.NamesDataContext db = new DataBaseClasses.NamesDataContext;

Should be :

DataBaseClasses.NamesDataContext db = new DataBaseClasses.NamesDataContext();

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

Sorry.  I put the () at the end so I have

DataBaseClasses.NamesDataContext db = new DataBaseClasses.NamesDataContext();

but still get the same error.

---

Harry T Ulmer

Answer 3

 

Is the NamesDataContext in the same project as where the code that is trying to instantiated it? If no, did you add a reference to the .dll in the project that you are creating the query to the project that has the NamesDataContext?

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 4

Yes.  The dataconmtext is in the same project.

---

Harry T Ulmer

Answer 5

 

Can you post a screen shot of the Solution Explorer here please.

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 6

Hi harrytu,

Any updates for your problem?

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.