public void InsertGuidPrimaryKey() { if (CI.IsTravis) { // Don't run SQL Server test on Linux return; } using (var con = new SqlServerDatabaseDriver().GetConnection()) { con.Execute("CREATE TABLE dbo.Bazs (Id UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), Name VARCHAR(255));"); object identity; try { DommelMapper.AddSqlBuilder(typeof(SqlConnection), new GuidSqlServerSqlBuilder()); identity = con.Insert(new Baz { Name = "blah" }); } finally { DommelMapper.AddSqlBuilder(typeof(SqlConnection), new DommelMapper.SqlServerSqlBuilder()); } Assert.NotNull(identity); var id = Assert.IsType <Guid>(identity); var baz = con.Get <Baz>(id); Assert.NotNull(baz); Assert.Equal("blah", baz.Name); Assert.Equal(id, baz.Id); con.Execute("DROP TABLE dbo.Bazs"); } }
public async Task InsertGuidPrimaryKey() { if (CI.IsTravis) { // Don't run SQL Server test on Linux return; } using var con = new SqlServerDatabaseDriver().GetConnection(); await con.ExecuteAsync("CREATE TABLE dbo.Quxs (Id UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), Name VARCHAR(255));"); try { object identity; try { DommelMapper.AddSqlBuilder(typeof(SqlConnection), new GuidSqlServerSqlBuilder()); identity = await con.InsertAsync(new Qux { Name = "blah" }); } finally { DommelMapper.AddSqlBuilder(typeof(SqlConnection), new SqlServerSqlBuilder()); } Assert.NotNull(identity); var id = Assert.IsType <Guid>(identity); var baz = await con.GetAsync <Qux>(id); Assert.NotNull(baz); Assert.Equal("blah", baz.Name); Assert.Equal(id, baz.Id); } finally { await con.ExecuteAsync("DROP TABLE dbo.Quxs"); } }