Localdb | Mssqllocaldb

public static void CreateDatabase(string databaseName) { string createDbQuery = $@" CREATE DATABASE [{databaseName}] ON PRIMARY (NAME = N'{databaseName}', FILENAME = N'{Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)}\\{databaseName}.mdf') LOG ON (NAME = N'{databaseName}_log', FILENAME = N'{Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)}\\{databaseName}_log.ldf')"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = new SqlCommand(createDbQuery, connection)) { command.ExecuteNonQuery(); Console.WriteLine($"Database '{databaseName}' created successfully!"); } } }

// DbContext class public class ApplicationDbContext : DbContext { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } localdb mssqllocaldb

public async Task<IEnumerable<User>> GetUsersAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync<User>("SELECT * FROM Users"); } using (var command = new SqlCommand(createDbQuery

public async Task<int> InsertUserAsync(User user) { using var connection = new SqlConnection(_connectionString); var sql = "INSERT INTO Users (Username, Email) VALUES (@Username, @Email); SELECT CAST(SCOPE_IDENTITY() as int)"; return await connection.QuerySingleAsync<int>(sql, user); } connection)) { command.ExecuteNonQuery()

This LocalDB instance is perfect for development, testing, and lightweight applications without needing a full SQL Server installation!

public LocalDBRepository(string databaseName) { _connectionString = $@"Server=(localdb)\MSSQLLocalDB;Database={databaseName};Trusted_Connection=true;"; }

var builder = WebApplication.CreateBuilder(args);