public static void Select()
{
FluentSelect<SICIL> select = new FluentSelect<SICIL>(':');
select.From("sicil").SelectAll().OrderBy(s => s.SICILKOD)
.Where()
.NotEquals(s => s.ADI, "Erhan")
.And()
.In(s => s.MEZUNBOLK, 1, 2, 3, 40, 41, 42, 43, 44, 45)
.Or()
.Not()
.Contains(s => s.SOYADI, "$$$")
.Or()
.GreaterThanOrEqualsTo(s => s.SICIL2K, 1)
.Or()
.Not()
.StartsWith(s => s.SICILNO, "12")
.Or()
.StartsWith(s=> s.ADI, "dsa")
.Or()
.EndsWith(s => s.SICILNO, "dsadsa")
;
var result = Util.Adapter.Query(select);
}
static async Task DbAccessExecuteTest()
{
using (ITransactionalDbAccess dataAccess = DataUtils.CreateTransactionalDataAccess())
{
DataTable dt = new DataTable();
dt.Load(await dataAccess.CreateDataReaderAsync("select * from SICIL"));
int result = await dataAccess.ExecuteNonQueryAsync("update MEZUNBOL SET MEZUNA=@0 WHERE MEZUNBOLK=@1", "Async", 256);
object val = await dataAccess.ExecuteScalarAsync("select TOP 1 MEZUNA from MEZUNBOL");
var arrayList = await dataAccess.ExecuteScalarListAsync("select MEZUNA from MEZUNBOL");
val = await dataAccess.ExecuteScalarSafelyAsync<decimal>("select TOP 1 MEZUNA from MEZUNBOL");
Console.WriteLine(val);
var genericList = await dataAccess.ExecuteScalarListAsync<string>("select MEZUNA from MEZUNBOL");
var expandoList = await dataAccess.QueryAsync("select * from PERSONELTIP");
var expando = await dataAccess.QuerySingleAsync("select top 1 * from PERSONELTIP");
var recordTable = await dataAccess.QueryRecordTableAsync("select * from SICIL".ToQuery(), "SICIL");
var dataTable = await dataAccess.QueryDataTableAsync("select * from SICIL");
dataAccess.Commit();
ICommandAdapter cmd = DataUtils.CreateCommandAdapter(dataAccess);
FluentSelect<MEZUNBOL> select = new FluentSelect<MEZUNBOL>('@');
var mezun = await cmd.QuerySingleAsync(select.SelectAll().Where().Equals(m => m.MEZUNBOLK, 18).AsSelect());
select = new FluentSelect<MEZUNBOL>('@');
var mezunList =
await cmd.QueryAsync(select.SelectAll().Where().NotEquals(m => m.MEZUNBOLK, 18).AsSelect());
result = await new FluentUpdate<MEZUNBOL>('@')
.Set(m => m.MEZUNA, mezun.MEZUNA + "fluent sync")
.Where().Equals(m => m.MEZUNBOLK, 18).AsUpdate().ExecuteAsync(dataAccess);
Console.WriteLine(result);
}
}
