public static bool Create(RbmDbCatalog entity) { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { try { var result = (int)session.Save(entity); // session.Update(entity); //session.Get<T>(id); // session.Delete(entity); transaction.Commit(); if (result > 0) { return(true); } } catch { transaction.Rollback(); throw; } } } return(false); }
public static void Do() { var dbCatalog = new RbmDbCatalog(); dbCatalog.DbCatalogName = "TestDb"; var rbTable = new RbmTable(); dbCatalog.Tables = new List <RbmTable>(); // rbTable.TableId = 1; rbTable.TableSchema = "dbo"; rbTable.DbCatalogId = 90; rbTable.DbCatalog = dbCatalog; dbCatalog.AddTables(rbTable); Helper.Create(dbCatalog); //f.Create<Report>(rpt); ///Delete many elements in one-to-may relationship //var obj1 = f.GetSelectedColumnsById(1); //Collection<SelectedColumn> selectedcolumns = new Collection<SelectedColumn>(); //foreach(object[] item in obj1) //{ // selectedcolumns.Add(new SelectedColumn {SID=(int) item[0],Columns = (string) item[1], Alias = (string) item[2], SortType = (string) item[3], SortOrder = (string) item[4], RID = (int) item[5] }); //} //f.Delete<SelectedColumn>(selectedcolumns); }