C# using linq to sql

14y1.9kVisual Basic .NET

Since I am new to working a C# 2010 console application, I have the following questions to ask about how to accomplish the following tasks:

1. I would like to use linq to sql on a sql server 2008 r2 database to pull all the data from one column in one particular table. The value for the one array would be varchar(50) There will be more than one row selected at the time. (What I have seen of linq so far is to pull only one value by using singleordefault.)

2. I then would like to take the values obtained from step number one and load those values into array,collection, or some type of similar object.

Can tell me how to accomplisth this goal and/or point me to a reference that I can use?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
If customer_id is a varchar, try:

string[] names = context.Customers.Where(c => c.customer_received_date != null).Select(c => c.customer_id).ToArray();
0
dc14y ago
Based upon your statement,
string[] names
= context.Customers.Select(c => c.Name).ToArray();

How would I change this statement to mean the following from the sql?

select customer_id from Customers where customer_received_date is not null
0
Vulpes14y ago
That's right.

Just access them as you normally would - so names[0] is the first name in the array, names[1] is the second and so forth.

To make sure it's giving the right answers you could iterate the array as follows:

foreach(string name in names) Console.WriteLine(name);
0
dc14y ago
So you are saying that I would have an array of string[] names?
Now how would I access each item (names) in the array?
0
Vulpes14y ago
Suppose you're pulling data from a Customer table in your database and that it's the Name column that you're interested in.

Then the code to do what you want will look something like this :

string[] names = context.Customers.Select(c => c.Name).ToArray();
0