public IList <TClase> Seleccionar <TClase>() where TClase : class { using (ISession session = NHelper.GetCurrentSession()) { return(session.CreateCriteria <TClase>().List <TClase>()); } }
public int ContadorRows <TClase>() where TClase : class { int rows = 0; using (ISession session = NHelper.GetCurrentSession()) { rows = session.QueryOver <TClase>() .Select(Projections.RowCount()) .FutureValue <int>() .Value; } return(rows); }
public List <System.Type> getEntidades() { List <System.Type> clases = null; var metaData = NHelper.GetCurrentSession().SessionFactory.GetAllClassMetadata(); if (metaData != null && metaData.Count > 0) { clases = new List <Type>(); foreach (var x in metaData) { var y = x.Value; Type xy; clases.Add(xy = y.GetMappedClass(EntityMode.Poco)); } } return(clases); }
public int Actualizacion(string sql) { int i = 0; using (ISession session = NHelper.GetCurrentSession()) { using (IDbConnection sql_con = session.Connection) { IDbCommand cmd = sql_con.CreateCommand(); cmd.CommandText = sql; i = cmd.ExecuteNonQuery(); } } return(i); }
public void Actualizar <TClase>(TClase Objeto) { try { using (ISession session = NHelper.GetCurrentSession()) { using (ITransaction transaction = session.BeginTransaction()) { session.Delete(Objeto); transaction.Commit(); } } } catch (Exception e) { Console.WriteLine("Error: " + e.Message); } }
public List <string> getEntidadesNombre() { List <string> tablas = null; var metaData = NHelper.GetCurrentSession().SessionFactory.GetAllClassMetadata(); if (metaData != null) { tablas = new List <string>(); foreach (var x in metaData) { var usrm = x.Value as NHibernate.Persister.Entity.AbstractEntityPersister; //var cols = usrm.KeyColumnNames; string table = usrm.TableName; tablas.Add(table); } } return(tablas); }
public DataTable Seleccionar(string sql) { DataTable dt; using (ISession session = NHelper.GetCurrentSession()) { using (IDbConnection sql_con = session.Connection) { dt = new DataTable(); IDbCommand cmd = sql_con.CreateCommand(); cmd.CommandText = sql; var reader = cmd.ExecuteReader(); dt = GetDataTableFromDataReader(reader); } } return(dt); }