public void GenerateInsertQuery_ColumnHasDefaultConstraintAndNonDefaultValue_Valid() { // Arrange var generator = new SqlQueryGenerator <HasDefaultConstraintEntity>("dbo", "Users"); var record = new HasDefaultConstraintEntity { Id = 42, DateCreated = DateTime.Now }; // Act var query = generator.GenerateInsertQuery(record); // Assert Assert.Equal("INSERT INTO [dbo].[Users] ([Id], [DateCreated]) OUTPUT [inserted].[Id], [inserted].[DateCreated] VALUES (@Id, @DateCreated);", query); }
public void GenerateInsertQuery_ColumnHasDefaultConstraintAndNonDefaultValue_Valid() { // Arrange var generator = new MySqlQueryGenerator <HasDefaultConstraintEntity>("Users"); var record = new HasDefaultConstraintEntity { Id = 42, DateCreated = DateTime.Now }; // Act var query = generator.GenerateInsertQuery(record); // Assert Assert.Equal(@"INSERT INTO Users (Id, DateCreated) VALUES (@Id, @DateCreated); SELECT Users.Id, Users.DateCreated FROM Users WHERE Users.Id = @Id;", query); }