// join samples
static void db_prod1s_proc_tmp()
{
CpnpArt CpnpArtAlias = null;
CpnpProd1s CpnpProd1SAlias = null;
ISession session = Models.NHibernateHelper.OpenSession();
//IQueryOver<CpnpProd1s, CpnpProd1s> pp =
// session.QueryOver<CpnpProd1s>(() => CpnpProd1SAlias)
// .JoinAlias(() => CpnpProd1SAlias.art,()=> CpnpArtAlias)
//Cat cat = null;
//Cat joinedCat = null;
// try
// {
/* var tt = session
* // .CreateSQLQuery("")
*
* .QueryOver<CpnpProd1s>(() => CpnpProd1SAlias)
* .JoinEntityAlias(
* () => CpnpArtAlias
* , () => CpnpProd1SAlias.art == CpnpArtAlias.art
* , JoinType.InnerJoin
* )
*
* .Select(c => CpnpArtAlias.cpnp, c => CpnpArtAlias.art
* , c => CpnpProd1SAlias.art, c => CpnpProd1SAlias.sname_1s)
* .List<object[]>();
*/
// foreach (var ss in tt) { Console.WriteLine("{0}\t{1}\t{2}", ss.art, ss.cpnp_exist, ss.sname_1s); }
// System.IO.File.WriteAllLines(@"d:\\aaa555.txt", tt.Select(ss => String.Format("{0}\t{1}\t{2}", ss.art, ss.cpnp_exist, ss.sname_1s)).ToArray());
// foreach (var ss in tt) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", ss[0],ss[1],ss[2], ss[3]); }
//System.IO.File.WriteAllLines(@"d:\\aaa444.txt", tt.Select(z => String.Format("{0}\t{1}\t{2}\t{3}", z[0], z[1], z[2], z[3])).ToArray());
//using (ISession session = Models.NHibernateHelper.OpenSession())
//{
// var testtable = session.QueryOver<CpnpProd1s>().List();
// foreach (var ss in testtable) { Console.WriteLine("{0}\t{2}\t{1}", ss.art, ss.sname_1s, ss.cpnp_exist); }
// //var list = session.QueryOver<Master>()
// // .JoinQueryOver(master => master.imagen)
// // .Where(imagen => imagen.linea.Id == 5)
// // .List();
//}
//}
//catch (Exception e) { Console.WriteLine(e.ToString()); }
}
/// <summary>
///
/// </summary>
public static void db_prod1s_proc()
{
CpnpArt CpnpArtAlias = null;
CpnpProd1s CpnpProd1SAlias = null;
ISession session = Models.NHibernateHelper.OpenSession();
var tt = session
.QueryOver <CpnpProd1s>(() => CpnpProd1SAlias)
.JoinEntityAlias(
() => CpnpArtAlias, () => CpnpProd1SAlias.art == CpnpArtAlias.art, JoinType.InnerJoin
)
.List();
foreach (var ss in tt)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}", ss.art, ss.sname_1s, ss.cpnp_exist.ToString(), ss.cpnp_to_add.ToString());
}
var tt2 = session
.QueryOver <CpnpProd1s>(() => CpnpProd1SAlias)
.List();
Console.WriteLine("total records 1: {0}\ntotal records 2: {1}", tt.Count().ToString(), tt2.Count().ToString());
// foreach (var ss in inidata.qu_List) { Console.WriteLine("{0}\n{1}", ss.id, ss.squery); }
//var result = session.CreateSQLQuery(inidata.qu_List[2].squery).List<object[]>();
//foreach (var ss in result) {
// Console.WriteLine(string.Join(",", ss.ToArray()));
// // Console.WriteLine("{0}\t", ss[1]);
//}
// example. SQL query execute
//ITransaction tx = session.BeginTransaction();
//var updatedEntities = session.CreateSQLQuery(inidata.qu_List[1].squery).ExecuteUpdate();
//tx.Commit();
//session.Close();
}
