(Asp.net) I can't Insert a new row using Linq to Sql

Question

So I'm trying to do a simple insert using Linq but i'm running into trouble.

code:

        TestDatacontext db = new TestDatacontext ();
        Comment com = new Comment();
        com.UserID = userId;
        com.TaskID = taskId;
        com.Description = Server.HtmlEncode(txtComments.Text);
        com.DateCreated = DateTime.Now;

Now at this point, from what I've read I should be able to do this:

db.Comments.Add(com);
db.Submitchanges();

However, when I write db.Comments. [There is no Add method]

So...how do I insert?

JustLoren · Accepted Answer · 2009-10-29 14:25:36Z

3

You're looking for db.Comments.InsertOnSubmit(com);

answered Oct 29, 2009 at 14:25

JustLoren

3,2343 gold badges31 silver badges34 bronze badges

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

2 Comments

Jack Marchetti Over a year ago

Thansk man! Why did I keep seeing db.Comments.Add(com); I saw it on ScottGu's blog and others.

JustLoren Over a year ago

Well if you had a parent object Entity that had children Comments, then you would do myEntity.Comments.Add(com); db.Entities.InsertOnSubmit(myEntity);, I believe.

Collectives™ on Stack Overflow

(Asp.net) I can't Insert a new row using Linq to Sql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related