DataReader vs DataSet vs DataAdapter vs DataTable

DataReader : DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader is used to iterate through resultset that came from server and it will read one record at a time because of that memory consumption will be …

How to use profiler on windows application

To optimize our applications we use Profilers.There are many profilers available on the web. But miniprofiler is the good one and it's not cost you any bucks. I recently faced a situation where I have to check the memory cunsomption by my console application to further optimize it. So I used an extended version of …

Deep Copy And Shallow Copy

What is Shallow Copy? Shallow copy is a bit-wise copy of an object. A new object is created that has an exact copy of the values in the original object. If any of the fields of the object are references to other objects, just the reference addresses are copied i.e., only the memory address is …

What is HTML5 Web Storage? localStorage and sessionStorage.

With HTML5, web pages can store data locally within the user’s browser. Earlier, this was done with cookies. However, Web Storage is more secure and faster. The data is not included with every server request, but used ONLY when asked for. The data is stored in name/value pairs, and a web page can only access …

Lazy, Eager, and Explicit Loading

There are several ways that the Entity Framework can load related data into the navigation properties of an entity: Lazy loading. When the entity is first read, related data isn't retrieved. However, the first time you attempt to access a navigation property, the data required for that navigation property is automatically retrieved. This results in …

Deferred vs Immediate Query Execution in LINQ

There are two ways of LINQ query execution as given below: Deferred Execution In case of differed execution, a query is not executed at the point of its declaration. It is executed when the Query variable is iterated by using loop like as for, foreach. DataContext context = new DataContext(); var query = from customer …

IEnumerable Vs IQueryable

IEnumerable  IQueryable Namespace System.Collections Namespace System.Linq Namespace Derives from No base interface Derives from IEnumerable Deferred Execution Supported Supported Lazy Loading Not Supported Supported How does it work IEnumerable is suitable just for iterate through collection and you can not modify (Add or Remove) data IEnumerable bring ALL data from server to client then filter …

How to allow only positive numeric value to a text box using jquery

Below is the nice piece of code which allows only positive numeric value to a text box. HTML: <input type="text" id="txtPostiveInt" /> Jquery: $(document).ready(function () { $('#txtPostiveInt').keyup(function () { var numbers = $(this).val(); $(this).val(numbers.replace(/\D+/, '')); }); });

How to get all Stored Procedure modified/created in last N days

I recently come through a situation where I forgot the name of the procedure modified by me few days back. After a search from Google I found many solutions and decided to put them on one place . For modified stored procedures : SELECT name,create_date, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < …

How to export results in to a file in SQL server 2008

Recently I countered a situation where I need to insert a bulk amount of data from a table in one database to another alias table in other database. For bulk insert I found out many solutions and this works for me correctly. But before that I need to export the data to a file, for …