forum

Home / DeveloperSection / Forums / LINQ to SQL array list insertion

Ask Question

LINQ to SQL array list insertion

Manoj Bhatt 2049 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?

asp.net asp.net  linq  sql  array 
Updated on 20-Nov-2014
Manoj Bhatt

Manoj Bhatt

Follow

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

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

Liked By