Posts by Pawan Shukla
Page 8 of 12

Difference between truncate and delete in sql

TRUNCATE When you TRUNCATE a table less information is logged.  This means the TRUNCATE statement executes very fast; however, it does so at the expense of not logging each row deleted. This means, that you need to be very careful when using the command (actually be careful with DELETE as well!). Truncate Syntax TRUNCATE TABLE UserMaster Truncate […]

Continue Reading →
 

Difference between firstordefault and singleordefault

Both are the element operators and they are used to select a single element from a sequence. But there is a minor difference between them. SingleOrDefault() operator would throw an exception if more than one elements are satisfied the condition where as FirstOrDefault() will not throw any exception for the same Single() – There is […]

Continue Reading →
 

Difference between function and procedure in sql

Functions and stored procedures are set of SQL statements that can be called by name. They have many similarities like they take arguments, used to perform required tasks and have same programming style and structure. But we are more interested in differences to grab the knowledge about power they held against each other. So here […]

Continue Reading →
 

What is LINQ

The descriptor LINQ is for Language Integrated question. Microsoft’s command language is totally integrated and offers simple information access from in-memory objects, databases, XML documents and plenty of additional. it’s through a collection of extensions, LINQ with competence integrate queries in C# and Visual Basic. The tutorial offers an entire insight into LINQ with ample […]

Continue Reading →