// 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(); }