Mssqllocaldb |work| - Localdb

Example to stop:

}

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')";

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); }

// appsettings.json { "ConnectionStrings": { "DefaultConnection": "Server=(localdb)\\MSSQLLocalDB;Database=MyAppDb;Trusted_Connection=true;MultipleActiveResultSets=true" } }

# Check if LocalDB is installed sqllocaldb info

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

return true; } catch (Exception ex) { Console.WriteLine($"✗ Error connecting to LocalDB: {ex.Message}"); Console.WriteLine("\nTroubleshooting steps:"); Console.WriteLine("1. Run 'sqllocaldb start MSSQLLocalDB' in command prompt"); Console.WriteLine("2. Ensure SQL Server LocalDB is installed"); Console.WriteLine("3. Check if Windows Firewall is blocking the connection"); return false; }

:

}

$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 }

Write-Host "Starting LocalDB instance: $InstanceName" -ForegroundColor Green & $localdbPath start $InstanceName