Localdb Mssqllocaldb [NEW]

builder.Services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

public async Task UpdateUserAsync(User user) { using var connection = new SqlConnection(_connectionString); var sql = "UPDATE Users SET Username = @Username, Email = @Email WHERE Id = @Id"; await connection.ExecuteAsync(sql, user); } } localdb mssqllocaldb

// 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;" builder

public LocalDBRepository(string databaseName) { _connectionString = $@"Server=(localdb)\MSSQLLocalDB;Database={databaseName};Trusted_Connection=true;"; } Username NVARCHAR(50) NOT NULL UNIQUE

public static void CreateTables() { string createTablesQuery = @" CREATE TABLE Users ( Id INT PRIMARY KEY IDENTITY(1,1), Username NVARCHAR(50) NOT NULL UNIQUE, Email NVARCHAR(100) NOT NULL, CreatedAt DATETIME2 DEFAULT GETDATE() ); CREATE TABLE Products ( Id INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(100) NOT NULL, Price DECIMAL(18,2) NOT NULL, Stock INT DEFAULT 0 );"; using (var connection = new SqlConnection(@"Server=(localdb)\MSSQLLocalDB;Database=MyApp;Trusted_Connection=true;")) { connection.Open(); using (var command = new SqlCommand(createTablesQuery, connection)) { command.ExecuteNonQuery(); Console.WriteLine("Tables created successfully!"); } } } } // appsettings.json { "ConnectionStrings": { "DefaultConnection": "Server=(localdb)\\MSSQLLocalDB;Database=MyAppDb;Trusted_Connection=true;MultipleActiveResultSets=true" } } // DbContext configuration in Program.cs (.NET 6+) using Microsoft.EntityFrameworkCore;