Can you tell about your experience with database management systems in projects?

In C# projects, I have used various DBMSs, including SQL Server, PostgreSQL, and SQLite. Typically, database interaction was implemented through the ORM Entity Framework, which simplified data handling and allowed writing queries in LINQ.

Example of using Entity Framework to retrieve a list of users:

using(var context = new AppDbContext())
{
    var users = context.Users.Where(u => u.IsActive).ToList();
}

I also worked with raw SQL queries via ADO.NET for optimization or specific operations. It was important to ensure query security by using parameterization to prevent SQL injection.

My experience includes designing database schemas, optimizing queries, and setting up indexes to improve performance.