public static void insert(string firstname, string lastname, int mobileno) { using (var session = NHibernatHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var contact = new Contact { FirstName = firstname, LastName = lastname, PhoneNo = mobileno }; session.Save(contact); transaction.Commit(); Console.WriteLine("Success"); } } }
static void Main(string[] args) { /* * using (var session = NHibernatHelper.OpenSession()) * { * using(var transaction = session.BeginTransaction()) * { * var contact = new Contact * { * FirstName = "Rahul", * LastName = "Shetye", * PhoneNo = 989273965 * }; * session.Save(contact); * transaction.Commit(); * Console.WriteLine("Success"); * * } * } */ // insert("Romy", "Rajan",98913123); // insert("Rohan", "Singh",123145); //insert("Vishal", "Singh", 52535252); //insert("Rahul", "Shetye", 32522353); // insert("Shehan", "Shetty", 233245); // update(); // Delete(); using (var session = NHibernatHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var contacts = session.Query <Contact>().Where(x => x.Id == 1).Where(x => x.FirstName == "Vishal").ToList(); foreach (var i in contacts) { Console.WriteLine($"{i.Id} {i.FirstName} {i.LastName} {i.PhoneNo}"); } } } Console.WriteLine("Success"); Console.ReadLine(); }
public static void Delete() { using (var session = NHibernatHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var contactlst = session.QueryOver <Contact>().List <Contact>(); Contact contact = new Contact();; foreach (var c in contactlst) { if (c.Id == 2) { contact = c; } } session.Delete(contact); transaction.Commit(); Console.WriteLine("Success"); } } }