protected void CreateTableFoo()
{
_dataClient.AddTable(tableFoo,
Column.Int32("id").AsPrimaryKey(),
Column.String("name")
);
}
public void Start(IDataClient client)
{
if (client.TableExists("users"))
{
client.RemoveTable("users");
}
client.AddTable("users",
AutoIncrement("id").AsPrimaryKey(),
String("username", 50).NotNull(),
String("password", 50).NotNull()
);
client.AddUniqueKey("un_users", "users", "username");
client.Insert
.Into("users")
.Columns("username", "password")
.Values("foo", "bar");
var users = client.Select
.AllColumns()
.From("users")
.Where(Filter.Eq("username", "foo"))
.SkipTake(0, 1)
.Map <User>();
foreach (var user in users)
{
Console.WriteLine("User: " + user.Username);
}
}
public void Can_query_with_string_filter()
{
_dataClient.AddTable(TableFoo,
Column.String("colString"),
Column.Int32("colInt"));
_dataClient.Insert.Into(TableFoo).Columns("colString", "colInt").Values("foo", 1);
ResultSet resultSet = _database.Query("select colString from foo where colString = :name",
In.Named("name", "foo"));
Assert.AreEqual("foo", resultSet[0][0].ToString());
}
public void Start(IDataClient client)
{
if (client.TableExists("users"))
{
client.RemoveTable("users");
}
client.AddTable("users",
AutoIncrement("id").AsPrimaryKey(),
String("username", 50).NotNull(),
String("password", 50).NotNull()
);
client.AddUniqueKey("un_users", "users", "username");
client.Insert
.Into("users")
.Columns("username", "password")
.Values("foo", "bar")
.Values("foo2", "bar")
.Values("foo3", "bar");
var userInsert = new UserInsert {
Username = "******",
Password = "******"
};
client.Insert
.Into("users")
.Object(userInsert);
userInsert.Username = "******";
var id = client.Insert
.Into("users")
.ObjectAnd(userInsert)
.Return <int>("Id");
var loadedUser = client.LoadById <User>("users", id, u => u.Id);
Console.WriteLine("LoadById User: "******"foo4";
var password = "******";
client.ExecSqlFormattable($"insert into users (username, password) values ({username}, {password})");
var users = client.Select
.AllColumns()
.From("users")
.Where(Filter.Eq("username", "foo"))
.OrderBy(OrderBy.Ascending("username"))
.SkipTake(0, 2)
.Map <User>();
Console.WriteLine("Count: " + users.Count);
foreach (var user in users)
{
Console.WriteLine("User: "******"foo%";
var foos = client.QueryFormattable($"select username, password from users where username like {filter}").Map <Foo>();
Console.WriteLine("Count: " + foos.Count);
foreach (var foo in foos)
{
Console.WriteLine("Foo: " + foo.Username);
}
Console.WriteLine("End----");
}
