Suggestions about Database

Need to retrieve data from a database?

A typical SQL query consists of these clauses:

• SELECT to choose columns
• FROM to specify the table
• JOIN to combine related tables
• WHERE to filter rows
• GROUP BY to group results
• HAVING to filter groups
• ORDER BY to sort data
• OFFSET / FETCH or LIMIT to paginate

Not every query needs every clause, but this is the structure you'll see in most SQL statements.

Understanding what each clause does makes reading and writing SQL much easier.

Queries running slowly?

Consider adding an index.

Indexes help SQL Server:

• Find data faster
• Reduce table scans
• Improve filtering performance
• Improve sorting performance
• Improve join performance

Not every column needs an index, but columns used in WHERE clauses often benefit from one.

What is your favorite indexing strategy?

Want asynchronous database writes in EF Core?

Use SaveChangesAsync() instead of SaveChanges().

Benefits:

• Doesn't block the calling thread
• Works better under load
• Integrates with async/await
• Recommended for ASP.NET Core applications
• Available since EF Core was released

What other EF Core performance tips do you use?