public DbSet<User> Users { get; set; } public DbSet<Product> Products { get; set; } }
This LocalDB instance is perfect for development, testing, and lightweight applications without needing a full SQL Server installation! localdb mssqllocaldb
public async Task<IEnumerable<User>> GetUsersAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync<User>("SELECT * FROM Users"); } public DbSet<User> Users { get; set; } public
// Default LocalDB connection string "Server=(localdb)\\MSSQLLocalDB;Database=MyDatabase;Trusted_Connection=true;" // With multiple Active Result Sets (MARS) "Server=(localdb)\MSSQLLocalDB;Database=MyDatabase;Trusted_Connection=true;MultipleActiveResultSets=true;" Users { get
// DbContext class public class ApplicationDbContext : DbContext { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { }