Insert multiple rows of data into the database wp8

Question

I know how to insert data into a database one by one but I want to insert multiple pieces of data into database and I don't know how to do this.

Here is my code for a "one-time" insert of data:

Bloggers BlogerToaddData = new Blogger
{
     Interest = txtIntrest.Text.ToString(),
     Name = txtname.Text.ToString(),
     Totalposts = Convert.ToInt32(txtPost.Text)
};

bloggerDB.bloggers.InsertOnSubmit(BlogerToaddData);
bloggerDB.SubmitChanges();

but how to insert multiple rows of data?

Bloggers BlogerToaddData = new Bloggers
{Interest = "wy",Name = "opwm",Totalposts =1},
{Interest = "wy",Name = "opwm",Totalposts =1},
{Interest = "wy",Name = "opwm",Totalposts =1},

This is not working

Jon Skeet · Accepted Answer · 2014-03-29 08:32:34Z

2

Well you need to create multiple objects. You can either add them one at a time to the list of pending changes:

var bloggs = bloggerDB.bloggers;
bloggers.InsertOnSubmit(new Bloggers { Interest = "wy", Name = "opwn", TotalPosts = 1 });
bloggers.InsertOnSubmit(new Bloggers { Interest = "ab", Name = "abcd", TotalPosts = 2 });
bloggers.InsertOnSubmit(new Bloggers { Interest = "cd", Name = "1234", TotalPosts = 3 });
bloggerDB.SubmitChanges();

Or use InsertAllOnSubmit:

bloggerDB.bloggers.InsertAllOnSubmit(new[] {
    new Bloggers { Interest = "wy", Name = "opwn", TotalPosts = 1 },
    new Bloggers { Interest = "ab", Name = "abcd", TotalPosts = 2 },
    new Bloggers { Interest = "cd", Name = "1234", TotalPosts = 3 }
});
bloggerDB.SubmitChanges();

answered Mar 29, 2014 at 8:32

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Collectives™ on Stack Overflow

Insert multiple rows of data into the database wp8

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related