How to read data from database and store it in array using linq to sql?

Question

I create a database with the data(id) 8,5,1,9,2,3,4,5. Then i want to retrieve the data and store it in an array. Does anyone can help me? I am using C# and linq to SQL.

My code:

using(DatabaseDataContext db = new DatabaseDataContext())
{
   var query = from p in db.table1
               select p.id;


   int[] myArray = new int[query];
}

-1 because you could simply have done a 5 minute search. I believe this question shows a significant lack of research effort. — Michael J. Gray
– Michael J. Gray, Commented Nov 9, 2012 at 8:07

tukaef · Accepted Answer · 2012-11-09 08:05:08Z

4

Just call an extension method ToArray():

var array = (from p in db.table1
             select p.id).ToArray();

answered Nov 9, 2012 at 8:05

tukaef

9,2544 gold badges32 silver badges47 bronze badges

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

2 Comments

Michael J. Gray Over a year ago

+1 because you answered faster than me. Perhaps you could mention that specifically the extension method is found in System.Linq.

Nerdynosaur Over a year ago

Wow, just that simple. Thanks!

Collectives™ on Stack Overflow

How to read data from database and store it in array 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