Query in LINQ pad

How to query in LINQ

query:


from a in new_cooldrinkSet
select new { cooldrink= a.new_name }


refer:

http://blogs.msdn.com/b/crm/archive/2011/01/11/a-better-way-to-learn-linq-to-crm-linqpad-plugin-for-ms-crm-2011-is-available.aspx

http://www.linqpad.net/

http://mscrmdev.blogspot.in/2012/01/crm-2011-linq-all-columns-vs-selected.html

http://stackoverflow.com/questions/6331562/dynamics-crm-2011-filtering-linq-query-with-outer-joins

http://stackoverflow.com/questions/11436835/how-to-query-using-linq-formattedvalues-in-dynamics-crm-2011

Where Condition:


from a in new_cooldrinkSet
where a.new_name.StartsWith("t")
select new { cooldrink= a.new_name }