LINQ Query

[trevorlawrence]

Hi All,

I want to use LINQ in my windows forms. Does anybody has got an idea of building dynamic queries depending on user selected tables and fields which are in a gridview.

Thanks for any suggestion in advance.
Trevor.

[jackydenel]

I often use function syntax for short expressions but query syntax tends to be more succinct so, for anything that requires more than a single function call, query syntax is often easier to read. As someone who spends about half my time in C#, I have to admit that VB’s verbose syntax can often get in the way too. Try writing an expression that involves a couple of generic arguments and a lambda expression or two and looking at the VB code can give you a headache. Function syntax in C# can be much easier to read than function syntax in VB so, in VB, I tend to use query syntax in most cases where I can.Function syntax gets a bit more of a workout in C# though. Query syntax in VB actually has some advantages over query syntax in C# too, like the ability to omit the Select clause if all you are selecting is the range variable itself, and also the Distinct key word.

[leenapaul76]

any body tell me what is the advantages of LINQ over ADO.NET

[jeremy84olsen]

You can use LINQ to SQL on a mid-sized project.
One disadvantage I see is that it adds another layer of code, and my understanding is that it has slower performance than using stored procedures and ADO.Net. It also seems that debugging could be a challenge, especially for more complex queries, and that these might end up being moved to a stored proc anyway.