Performance tip about List


If we want to maintain a list of data, the first way that comes to mind is List or Array. In this article, we want to review a point about the space occupied by List. The List class uses an internal array to store elements. ....
Read more

The difference between AsNoTracking and AsNoTrackingWithIdentityResolution


In the Entity Framework, every time we read one or more records of data from the database, they are tracked by ChangeTracker by default. And that gives us some performance reduction ....
Read more

Implementing NOLOCK in EntityFramework


In SQL when the records to be BULK INSERT stored large number of records SQL table to Lock and until all the data into SQL will not be able to get a data table read (by default). But in SQL itself you can read data UnCommited from tables. This can only retrieve data that is not Commit ....
Read more

تفاوت IQueryable و IEnumerable


اولین نکته مهم که باید به یاد داشته باشیم آن است که اینترفیس IQueryable از اینترفیس IEnumerable ارث بری کرده است. این بدان معناست هز کاری که اینترفیس IEnumerable میتواند انجام دهد اینترفیس IQueryable نیز میتواند. تفاوت های زیادی بین بین این دو اینترفیس وجود دار ....
Read more