public bool SetSuperAdmin() { using (MySqlConnection connection = new MySqlConnection(_connectionString)) { connection.Open(); MySqlTransaction transaction = connection.BeginTransaction(); User user = null; try { using (CafeBarContext contextDB = new CafeBarContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } //DbConnection that is already opened using (CafeBarContext context = new CafeBarContext(connection, false)) { //Interception / SQL logging context.Database.Log = (string message) => { Console.WriteLine(message); }; //Passing an existing transaction to the context context.Database.UseTransaction(transaction); if (!context.UserSet.Any(x => x.Username == "admin")) { context.UserSet.Add(new User() { DateCreated = DateTime.Now, IsLocked = false, HashedPassword = "******", Email = "*****@*****.**", Salt = "lobon", Username = "******" }); } context.SaveChanges(); } transaction.Commit(); } catch (DbEntityValidationException ex) { transaction.Rollback(); return(false); } return(true); } }
public static void ExecuteExample() { string connectionString = "Server=localhost;Port=3306;Database=cafebar;user id=root;password=1234;"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { //Create database if not exists using (CafeBarContext contextDB = new CafeBarContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } //connection.ConnectionString += ";password=1234;"; connection.Open(); MySqlTransaction transaction = connection.BeginTransaction(); try { //DbConnection that is already opened using (CafeBarContext context = new CafeBarContext(connection, false)) { //Interception / SQL logging context.Database.Log = (string message) => { Console.WriteLine(message); }; //Passing an existing transaction to the context context.Database.UseTransaction(transaction); //DbSet.AddRange // List<Category> cars = new List<Category>(); //cars.Add(new Category { Name = "Nissan2" }); // Console.WriteLine(context.Database.ExecuteSqlCommand(TransactionalBehavior.EnsureTransaction, "select * from categories")); // context.SaveChanges(); } transaction.Commit(); } catch { transaction.Rollback(); throw; } } }
public User CheckLogin(LogInModel model) { using (MySqlConnection connection = new MySqlConnection(_connectionString)) { using (CafeBarContext contextDB = new CafeBarContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } connection.Open(); MySqlTransaction transaction = connection.BeginTransaction(); User user = null; try { //DbConnection that is already opened using (CafeBarContext context = new CafeBarContext(connection, false)) { //Interception / SQL logging context.Database.Log = (string message) => { Console.WriteLine(message); }; //Passing an existing transaction to the context context.Database.UseTransaction(transaction); user = context.UserSet.FirstOrDefault(x => x.Email == model.Email && x.HashedPassword == model.Password); // context.SaveChanges(); } transaction.Commit(); } catch { transaction.Rollback(); } return(user); } }