First vs FirstOrDefault in LINQ

First vs FirstOrDefault in LINQ

S.No	First	FirstOrDefault
1	Gives first record from the collection, if collection doesn't have any object then throws error.	FirstOrDefault extension method is used to retrieve the first element from the collection, if not then gives null

LINQ To SQL and LINQ To Object

LINQ To SQL and LINQ To Object

S.No	LINQ To SQL	LINQ To Object
1	needs a Data Context object.	doesn’t need any intermediate LINQ provider or API.
2	returns data of type IQueryable.	returns data of type IEnumerable.
3	translated to SQL by way of Expression Trees, which allow them to be evaluated as a single unit and translated to the appropriate and optimal SQL statements	does not need to be translated.
4	translated to SQL calls and executed on the specified database.	executed in the local machine memory.

Last vs LastOrDefault in LINQ

Last vs LastOrDefault in LINQ

S.No	Last	LastOrDefaulf
1	Last extension method gives last element from the collection. If there is no element in the collection, it throws error.	LastOrDefault extension method gives the last element form the collection, if not gives null.

Constants Vs Read-only

Constants Vs Read-only

S.No	Constants	Read-only
1	Constants are dealt with at compile-time.	Read-only variables are evaluated at runtime.
2	Constants supports value-type variables.	Read-only variables can hold reference type variables.
3	Constants should be used when it is very unlikely that the value will ever change.	Read-only variables should be used when run-time calculation is required.

Double.Parse Vs ConvertTo.Double

Double.Parse Vs ConvertTo.Double

S.No	Particulars	Double.Parse	ConvertTo.Double
1	thrown error	thrown error.	Doen not thrown error,Return O Value.

Int.Parse Vs Convert.ToInt32

Int.Parse Vs Convert.ToInt32

S.No	Particulars	Int.Parse	Convert.ToInt32
1	thrown error	thrown error.	Doen not thrown error,Return O Value.

Local Temp Table Vs Global Temp Table

Local Temp Table Vs Global Temp Table

S.No	Particulars	Local Temp Table	Global Temp Table
1	Available	SQL Server session or connection (means single user).	all SQL Server sessions or connections (means all the user).
2	Deleted	These are automatically deleted when the session that created the tables has been closed.	These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed.
3	Stared with sign	Local temporary table name is stared with single hash ("#") sign.	Global temporary table name is stared with double hash ("##") sign.

ComboBox vs List Box

ComboBox vs List Box

S.No	Particulars	ComboBox	ListBox
1	Select	One Data.	Multiple Data.
2	Facility	Drop Down Facility.	Drop up and Drop Down Facility.
3	Check Box	can't Use CheckBox.	Can use Check Box.

Dynamic vs Anonymous Type

. Dynamic vs Anonymous Type

S.No	Particulars	Dynamic	Anonymous types
1	Run time	Dynamic types work at run time by late binding of object properties.	Anonymous types cause the compile time errors.
2	Keyword	Dynamic Keyword	Var Keyword.

LINQ Vs DLINQ Vs XLINQ

LINQ Vs DLINQ Vs XLINQ

S.No	LINQ	DLINQ	XLINQ
1	programming model that introduces queries as a first-class concept into any Microsoft .NET language.	an extension to Linq that allows querying a database and do object-relational mapping.	an extension to Linq that allows querying XML documents, as well as creating or transforming XML.