How Do I Get Started with LINQ to XML?
Simple Object Model and Query using LINQ to SQL
.NET Framework 4: LINQ to DataSet
.NET Framework 4: Basic LINQ Query Operations (C#)
Most the time when we work with a list object, finding a newly added items or deleted items becomes a very trivial part of the logic. Sometimes, we endup writing sophisticated logic or loops to get this done. Below code will demonstrate how this can be easily done using LINQ. Lets assume that we have [...]
There are quite a lot of instance where you need to do a primary sort and you need a secondary sort on the same collection and sometimes even multiple sort. With LINQ we can achieve it pretty straight forward. Let us assume the situation here. We have a list of employees and we need the [...]
In this tips I am going to show how you can deal with the Nullable values in LINQ queries and how you can achieve functionality like SQL ISNULL function. Let’s put it as a problem statement I am dealing with the LINQ queries, In which I have to diplay “N/A” were the value is null [...]
This small tips discussed about how to get list of duplicate items for the collection that we do in sql. For example I have to get list of the email id which is get entered in user table more than one time. [sourcecode language="csharp"] SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING [...]
SelectMany is Projects each element of a sequence to an IEnumerable and flattens the resulting sequences into one sequence.In this post I am going to show how you can use SelectMany Extension method to achieve the join between related tables easily without writing long queries. To understand this consider example below As shown in [...]
In this tips I have discussed about how to get the difference between two table/ entity sets. As for example we want to get rows form table_A which are not exists in table_B. (When table_A primarykey is part of table_B foreignkey). Following is way to get the row(s) form table_A which are not part of [...]
|
|
|
|
|
|
|
|
|
Join our other bookmarking sites
|
|
|
|
|
