Junior — Middle
What database management systems have you used in your projects?
sobes.tech AI
Answer from AI
In C# projects, the following DBMSs are often used:
- Microsoft SQL Server — the standard choice for .NET applications, well integrated with Entity Framework.
- PostgreSQL — popular due to its openness and advanced features.
- MySQL — frequently used in web projects.
- SQLite — used for lightweight applications or testing.
Example of connecting to MS SQL Server using Entity Framework Core:
var options = new DbContextOptionsBuilder<MyDbContext>()
.UseSqlServer("Server=.;Database=MyDb;Trusted_Connection=True;")
.Options;
using var context = new MyDbContext(options);
// work with the database