private async void TestEF6C1C2()
{
Class1 c1 = new Class1();
EntityGenerator <Class1> generatorClass1 = new EntityGenerator <Class1>();
c1 = generatorClass1.GenerateItem();
EntityGenerator <Class2> generatorClass2 = new EntityGenerator <Class2>();
for (int i = 0; i < 10; i++)
{
c1.Addresses.Add(generatorClass2.GenerateItem());
}
MySQLManager <Class1> managerClass1 = new MySQLManager <Class1>(DataConnectionResource.LOCALMYSQL);
c1 = await managerClass1.Insert(c1);
Class1 c11 = await managerClass1.Get(c1.Id);
//Class1 client = managerClass1.DbSetT.SqlQuery("SELECT * FROM " + Class1Schema.TABLE + " WHERE id = 1",new object[] { }).ToListAsync().Result[0];
//Class1 client = managerClass1.DbSetT.SqlQuery("@param1, @param2, @param3",
// new SqlParameter("param1", "SELECT * FROM "),
// new SqlParameter("param2", Class1Schema.TABLE),
// new SqlParameter("param3", " WHERE id = 1")).FirstAsync().Result;
//var result = await managerClass1.DbSetT.SqlQuery("SELECT " + Class1Schema.ID + ", " + Class1Schema.NAME + ", " + Class1Schema.SURNAME + ", " + Class1Schema.ADDRESS_ID +" FROM " + Class1Schema.TABLE).ToListAsync();
//Func<Class1, Boolean> testFunction = new Func<Class1, bool>((x, y) =>
//{
// if (true)
// {
// return true;
// }
// else
// {
// return false;
// }
//});
//var result1 = managerClass1.DbSetT.SqlQuery("SELECT * FROM "+ Class1Schema.TABLE + ";").AllAsync(testFunction);
String queryString = string.Format("SELECT * FROM {0} {1} {2} {3} {4};", Class1Schema.TABLE, "WHERE", Class1Schema.NAME, "LIKE", "'%s'");
queryString = string.Format("SELECT * FROM {0};", Class1Schema.TABLE);
var result = await managerClass1.DbSetT.SqlQuery(queryString).ToListAsync();
Criteria criteria = new Criteria(DbAction.SELECT, EnumString.GetStringValue(DbSelector.ALL));
criteria.AddDbLink(Class1Schema.TABLE, DbLinks.FROM);
criteria.AddDbLink(Class2Schema.TABLE, DbLinks.INNERJOIN, new LinkCondition(Class1Schema.PREFIX_ADDRESS_ID, Class2Schema.PREFIX_ID));
criteria.AddCriterion(new Criterion(DbVerb.EMPTY, Class1Schema.NAME, DbOperator.LIKE, "'%s'"));
criteria.AddCriterion(new Criterion(DbVerb.OR, Class1Schema.SURNAME, DbOperator.IN, "('RebeckaGotts', 'JesseAguas')"));
String value = criteria.MySQLCompute();
var result1 = await managerClass1.CustomQuery(criteria);
//MySQLManager<Class2> managerClass2 = new MySQLManager<Class2>(DataConnectionResource.LOCALMYSQL);
//Criteria criteria1 = new Criteria(DbAction.DELETE, Class1Schema.ALL_TABLE_ELEMENT + ", " + Class2Schema.ALL_TABLE_ELEMENT);
//criteria1.AddDbLink(Class2Schema.TABLE, DbLinks.FROM);
//criteria1.AddDbLink(Class1Schema.TABLE, DbLinks.INNERJOIN, new LinkCondition(Class2Schema.PREFIX_CLASS1_ID, Class1Schema.PREFIX_ID));
//criteria1.AddCriterion(new Criterion(DbVerb.EMPTY, Class2Schema.PREFIX_CLASS1_ID, DbOperator.SUPERIOREQUAL, "4"));
//String value1 = criteria1.MySQLCompute();
//await managerClass2.CustomQuery(criteria1);
}
