public void get_column_value()
{
var post = new Post()
{
Title = "title12"
};
var id = _db.Insert(post).InsertedId <int>();
Assert.Equal("title12", _db.GetColumnValue <Post, string>(p => p.Title, p => p.Id == id));
Assert.Null(_db.GetColumnValue <Post, string>(p => p.Title, p => p.Id == 2890));
}
public void insert_sql()
{
Config.EmptyTable();
var id = _db.Insert(new Post {
Title = "Test", AuthorId = 1, TopicId = null, Type = PostType.Post, CreatedOn = DateTime.UtcNow
}).InsertedId <int>();
Assert.Equal(1, id);
id = _db.Insert(new Post {
Title = "Test", AuthorId = 1, TopicId = null, Type = PostType.Post, CreatedOn = DateTime.UtcNow
}).InsertedId <int>();
Assert.Equal(2, id);
}
public override void Inserts(BenchmarksContainer bc)
{
var p = sfPosts.Create();
bc.Add(id =>
{
_db.Insert(p);
}, "SqlFu");
}
public void identity_is_set()
{
Table.ExecuteDDL();
Assert.Equal(1, Db.Insert(TableName, new { Name = "ha" }).InsertedId <int>());
}
public void change_gender_to_varchar()
{
_table.Columns.Change("Gender").SetType(DbType.String, "1").SetDefault("M");
_table.ExecuteDDL();
Assert.DoesNotThrow(() => _db.Insert("users", new { Gender = "F" }));
}
