---
title: "LINQ to SQL array list insertion"  
description: "LINQ to SQL array list insertion"  
author: "Manoj Bhatt"  
published: 2014-11-20  
updated: 2014-11-20  
canonical: https://www.mindstick.com/forum/12665/linq-to-sql-array-list-insertion  
category: "asp.net"  
tags: ["asp.net", "linq", "sql", "array"]  
reading_time: 1 minute  

---

# LINQ to SQL array list insertion

how [insert data](https://www.mindstick.com/forum/33964/insert-data-in-datagridview-from-text-box-c-sharp) [array](https://www.mindstick.com/articles/335/jagged-array-in-c-sharp-dot-net) to [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) with [linq to sql](https://www.mindstick.com/articles/338528/how-to-use-linq-to-sql-select-query-using-c-sharp)?

```
 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?

## Replies

### Reply by Sumit Kesarwani

```
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](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net) a new item for each entry in the string array


---

Original Source: https://www.mindstick.com/forum/12665/linq-to-sql-array-list-insertion

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.