public static void Add(PluginInfo plugin) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start and open Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action to save data. session.Save(plugin); transaction.Commit(); }//End Using trasaction }//End Using session }
public Domain.Socioboard.Domain.PluginInfo getUrlInfo(string Url) { List<PluginInfo> lstUser = new List<PluginInfo>(); PluginInfo user = new PluginInfo(); using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { lstUser = session.Query<Domain.Socioboard.Domain.PluginInfo>().Where(x => x.url.Contains(Url)).ToList(); user=lstUser[0]; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); user = null; } } } return user; }