private static async Task TestSqlServer() { var db = new SimpleData().Open(@"data source=.\SQLEXPRESS;initial catalog=Simple;integrated security=true", typeof(SqlServerAdapter)); var starship = await db.Starships.GetById(42); Console.WriteLine(starship.Name); }
private static async Task TestPostgres() { try { using (var cn = new NpgsqlConnection("Host=localhost;Username=postgres;Password=secretsquirrel")) { await cn.OpenAsync(); using (var cmd = new NpgsqlCommand("CREATE DATABASE simple", cn)) { await cmd.ExecuteNonQueryAsync(); } System.Console.WriteLine("Created database"); } } catch {} try { using (var cn = new NpgsqlConnection("Host=localhost;Username=postgres;Password=secretsquirrel;Database=simple")) { await cn.OpenAsync(); using (var cmd = new NpgsqlCommand("CREATE TABLE Starships (Id integer not null, Name varchar(100) not null)", cn)) { await cmd.ExecuteNonQueryAsync(); } using (var cmd = new NpgsqlCommand("INSERT INTO Starships VALUES (42, 'Heart of Gold')", cn)) { await cmd.ExecuteNonQueryAsync(); } System.Console.WriteLine("Created table"); } } catch {} var db = new SimpleData().Open(@"Host=localhost;Username=postgres;Password=secretsquirrel;Database=simple", typeof(PostgresAdapter)); var starship = await db.Starships.GetById(42); Console.WriteLine(starship.Name); }