In projects where several instances are on the server and use MemoryCache , one of the problems is managing their Memory Cache. For example, on one instance there is data inside the Memory that is different from other instances ....

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. ....

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 ....

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 ....

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