Localdb | Mssqllocaldb

public DbSet<User> Users { get; set; } public DbSet<Product> Products { get; set; } }

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

// Attach a specific MDF file "Server=(localdb)\MSSQLLocalDB;AttachDbFileName=C:\Data\MyDatabase.mdf;Database=MyDatabase;Trusted_Connection=true;" # Check if LocalDB is installed sqllocaldb info Create a new LocalDB instance sqllocaldb create "MyInstance" Start the LocalDB instance sqllocaldb start "MyInstance" Get connection string for the instance sqllocaldb info "MyInstance" Stop the instance sqllocaldb stop "MyInstance" Delete the instance sqllocaldb delete "MyInstance" List all instances sqllocaldb i 3. C# - Create Database Programmatically using System.Data.SqlClient; public class LocalDBSetup { private const string ConnectionString = @"Server=(localdb)\MSSQLLocalDB;Trusted_Connection=true;"; public DbSet&lt;User&gt; Users { get; set; } public

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!"); } } } Users { get