vetrivelmp - Professional Profile

Vetrivel is a Software Development Professional specialized in Microsoft technologies from 2008.He is living in coimbatore.

http://stackoverflow.com/questions/560453/linq-with-left-join-on-subquery-containing-count http://stackoverflow.com/questions/21184/how-do-i-use-linq-for-paging-a-generic-collection
http://stackoverflow.com/questions/78468/linq-to-entity-with-multiple-left-outer-joins
http://msdn.microsoft.com/en-us/library/bb397941.aspx
http://www.linqpad.net/WhyLINQBeatsSQL.aspx
http://www.linqpad.net/HowLINQPadWorks.aspx
Linqpad is to know how linq query is converted into sql query but Linqer is to convert sql query to LINq
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=21 http://forums.asp.net/t/1455444.aspx/1
http://stackoverflow.com/questions/6018756/howto-delete-rows-from-datatable-in-c-sharp-with-a-filter

#region Delete Query
var varTableRows = from DataRow dr in dtSample.Rows where dr.Field<string>("ID") == "121"
select dr;string strMaxDate = varTableRows.Max(x =>(string) x["Date"]);varTableRows.Where(x => string.Compare((string) x["Date"], strMaxDate,true)<0).ToList().ForEach(x => x.Delete());int intTableCount = dtSample.Rows.Count;
#endregion
#region LeftOuter Join
var varLeftOuterJoin = from objCustomers in Customers
join objOrders in Orders on objCustomers.CustomerID equals objOrders.CustomerID into LFGroup from anyThingFromLFGroup in LFGroup.DefaultIfEmpty()
select new{ CustomerName = objCustomers.Name, OrderCount = (anyThingFromLFGroup==null?0:anyThingFromLFGroup.CustomerID)};

foreach (var varTemp in varLeftOuterJoin)
{

}