Click here to Skip to main content
15,116,653 members

vetrivelmp - Professional Profile



Summary

    Blog RSS
7
Enquirer
142
Organiser
701
Participant
0
Author
0
Authority
0
Debator
0
Editor
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)
{

}


Reputation

Weekly Data. Recent events may not appear immediately. For information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilver
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSubEditor, Mentor, Protector, Editor
Store personal files in your account areaplatinumplatinumSubEditor, Editor
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Edit a Question in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Edit an Answer in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Delete a Question in Q&AYesSubEditor, Protector, Editor
Delete an Answer in Q&AYesSubEditor, Protector, Editor
Report an ArticlesilversilversilversilverSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubEditor, Mentor, Protector, Editor
Edit other members' articlesSubEditor, Protector, Editor
Create an article without requiring moderationplatinumSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending QuestionProtector
Approve/Disapprove a pending AnswerProtector
Report a forum messagesilversilverbronzeProtector, Editor
Approve/Disapprove a pending Forum MessageProtector
Have the ability to send direct emails to members in the forumsProtector
Create a new tagsilversilversilversilver
Modify a tagsilversilversilversilver

Actions with a green tick can be performed by this member.


 
-- There are no messages in this forum --