// In Package Manager Console or CLI: // Add-Migration InitialCreate // Update-Database # Create-DevDatabase.ps1 param( [string]$InstanceName = "MSSQLLocalDB", [string]$DatabaseName = "DevDatabase" ) Check if SQL LocalDB is installed $localdbPath = "C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" if (-not (Test-Path $localdbPath)) { Write-Error "SQL LocalDB not found. Please install SQL Server LocalDB." exit 1 } Start LocalDB instance Write-Host "Starting LocalDB instance: $InstanceName" -ForegroundColor Green & $localdbPath start $InstanceName Get connection string $connectionString = "Server=(localdb)$InstanceName;Trusted_Connection=true;" Create database $query = "CREATE DATABASE [$DatabaseName]" Invoke-Sqlcmd -ConnectionString $connectionString -Query $query
var builder = WebApplication.CreateBuilder(args); localdb mssqllocaldb
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; // In Package Manager Console or CLI: //
Write-Host "Database '$DatabaseName' created successfully!" -ForegroundColor Green Write-Host "Connection string: Server=(localdb)$InstanceName;Database=$DatabaseName;Trusted_Connection=true;" -ForegroundColor Yellow using Dapper; using System.Data.SqlClient; public class LocalDBRepository { private readonly string _connectionString; Username NVARCHAR(50) NOT NULL UNIQUE
public LocalDBRepository(string databaseName) { _connectionString = $@"Server=(localdb)\MSSQLLocalDB;Database={databaseName};Trusted_Connection=true;"; }
// DbContext class public class ApplicationDbContext : DbContext { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { }
// 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;"