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----"); }