Conversion Operators

Home	Table Design

ToArray

This sample uses ToArray to immediately evaluate a sequence into an array.

DataClassesDataContext db = new DataClassesDataContext();

LINQ:

var result = from c in db.Customers
select c.Name;

var NameArray = result.ToArray();

Lambda:

var result = db.Customers.Select(c => c.Name).ToArray();

for (int i = 0; i < NameArray.Length; i++)
Response.Output.WriteLine("{0}<br> ", NameArray[i]);

Result:

Rachit Rokad
Poonam Makati
Ayush Patel
Nenshi
Yuti Vachani

ToList

This sample uses ToList to immediately evaluate a sequence into a List<T>.

DataClassesDataContext db = new DataClassesDataContext();

LINQ:

var result = from c in db.Customers
select c.Name;

var NameList = result.ToList();

Lambda:

var result = db.Customers.Select(c => c.Name).ToList();

foreach (var item in NameList)
Response.Output.WriteLine("{0}<br> ", item);

Result:

Rachit Rokad
Poonam Makati
Ayush Patel
Nenshi
Yuti Vachani

ToDictionary

This sample uses ToDictionary to immediately evaluate a sequence and a related key expression into a dictionary.

DataClassesDataContext db = new DataClassesDataContext();
var result = from c in db.Customers
select new { c.CustID , c.Name, c.Education};

var NameDict = result.ToDictionary(sr => sr.CustID);

foreach (var item in NameDict)
Response.Output.WriteLine("{0} {1} {2}<br> ",
item.Key, item.Value.Name, item.Value.Education);

Result:

1 Rachit Rokad MCA
2 Poonam Makati MCA
3 Ayush Patel 2
4 Nenshi BE-Comm
5 Yuti Vachani 8

==============================================
Shradhdha Zalavadiya |Senior Software Engineer

WebMingle Technology
Accelerated by knowledge. Driven by values.
www.webMingle.in