𝐓𝐢𝐩𝐬 𝐭𝐨 𝐰𝐫𝐢𝐭𝐞 𝐛𝐞𝐭𝐭𝐞𝐫 𝐋𝐈𝐍𝐐 𝐐𝐮𝐞𝐫𝐢𝐞𝐬

𝐔𝐬𝐞 𝐨𝐟 𝐀𝐬𝐍𝐨𝐓𝐫𝐚𝐜𝐤𝐢𝐧𝐠 : For read only queries e.g. (GetAll,GetById etc.) use AsNoTracking , when we use it entities are not tracked for change so it brings data more speedily.

𝐈𝐧𝐜𝐥𝐮𝐝𝐞 𝐧𝐞𝐜𝐞𝐬𝐬𝐚𝐫𝐲 𝐄𝐧𝐭𝐢𝐭𝐢𝐞𝐬 𝐚𝐧𝐝 𝐂𝐨𝐥𝐮𝐦𝐧𝐬 : While retrieving data from multiple table make sure to include only necessary tables if you add tables that are not needed it will increase headache of query. Use eager loading only when it is necessary. Similarly don’t select the all columns from table , just retrieve necessary columns information using SELECT

𝐅𝐨𝐫 𝐥𝐚𝐫𝐠𝐞 𝐝𝐚𝐭𝐚 𝐮𝐬𝐞 𝐒𝐤𝐢𝐩 𝐚𝐧𝐝 𝐓𝐚𝐤𝐞 : When you are dealing with a lot of information use skip and Take to retrieve data from table because if we try to bring all data in single try it can take time that will give bad user experience Skip & Take two integer and skips provided values and then takes next values.

𝐔𝐬𝐞 𝐚𝐬𝐲𝐧𝐜 𝐦𝐞𝐭𝐡𝐨𝐝𝐬 : For better user experience use async methods e.g. FirstOrDefaultAsync , SingleOrDefaultAsync and ToListAsync

𝐑𝐞𝐝𝐮𝐜𝐞 𝐓𝐫𝐢𝐩𝐬 𝐭𝐨 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 : Use bulk operations available for SAVE/DELETE operations instead of iterating one by one it will reduce trips to database. After that only write one line await _context.SaveChangesAsync(); to reflect changes over database.

𝐔𝐬𝐞 𝐓𝐫𝐲𝐆𝐞𝐭𝐍𝐨𝐧𝐄𝐧𝐮𝐦𝐞𝐫𝐚𝐭𝐞𝐝𝐂𝐨𝐮𝐧𝐭 : While working with large collection of data we use pagination and our pagination is displayed on the basis of total records available. So instead of .Count() method use TryGetNonEnumeratedCount it attempts to determine the number of elements in a sequence without forcing an enumeration.

𝐔𝐬𝐞 𝐨𝐟 𝐈𝐐𝐮𝐞𝐫𝐲𝐚𝐛𝐥𝐞 : When you are dealing with a long list of filters and your filters are condition based make use of IQueryable ,it executes queries on the server side. After all conditions we can use .ToList() to fetch data , so it makes query faster because we are first creating complete query and then we are bringing the data.