LINQ to SQL array list insertion

Manoj Bhatt 2416 20 Nov 2014

how insert data array to database with linq to sql?

 DataClassesDataContext db = new DataClassesDataContext();
    simpleTbl tbl = new simpleTbl();
    string[] str =File.ReadAllLines(Server.MapPath("~/str.txt"));
 
    for (int i = 0; i <= 10; i++)
    {
       tbl.Name =str[i];
    }
  db.simpleTbl.InsertOnSubmit(tbl);
    db.SubmitChanges();

but dosen't work

How to do this?

Manoj Bhatt

Other

1 Answers

Sumit Kesarwani 20 Nov 2014

using(DataClassesDataContext db = new DataClassesDataContext())
{
    string[] strings =File.ReadAllLines(Server.MapPath("~/str.txt"));
    foreach (var str in strings )
    {
       
db.simpleTbl.InsertOnSubmit(new simpleTbl(){ Name = str });
    }
   
db.SubmitChanges();
}

You need to insert a new item for each entry in the string array

forum

LINQ to SQL array list insertion

Can you answer this question?

1 Answers