public override string ExecuteScript(string script) { string exceptions = ExecuteScriptInternal(UpgradeConnectionString, script); //if the upgrade connection string is specified or or db_owner setting is not set to dbo if (UpgradeConnectionString != ConnectionString || DatabaseOwner.Trim().ToLower() != "dbo.") { try { //grant execute rights to the public role or userid for all stored procedures. This is //necesary because the UpgradeConnectionString will create stored procedures //which restrict execute permissions for the ConnectionString user account. This is also //necessary when db_owner is not set to "dbo" exceptions += GrantStoredProceduresPermission("EXECUTE", GetConnectionStringUserID()); } catch (SqlException objException) { Logger.Debug(objException); exceptions += objException + Environment.NewLine + Environment.NewLine + script + Environment.NewLine + Environment.NewLine; } try { //grant execute or select rights to the public role or userid for all user defined functions based //on what type of function it is (scalar function or table function). This is //necesary because the UpgradeConnectionString will create user defined functions //which restrict execute permissions for the ConnectionString user account. This is also //necessary when db_owner is not set to "dbo" exceptions += GrantUserDefinedFunctionsPermission("EXECUTE", "SELECT", GetConnectionStringUserID()); } catch (SqlException objException) { Logger.Debug(objException); exceptions += objException + Environment.NewLine + Environment.NewLine + script + Environment.NewLine + Environment.NewLine; } } return(exceptions); }
public SqlDataProvider() { // Read the configuration specific information for this provider var providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data"); var objProvider = (Provider)(providerConfiguration.Providers[providerConfiguration.DefaultProvider]); // Read the attributes for this provider ConnectionString = Config.GetConnectionString(); ProviderPath = objProvider.Attributes["providerPath"]; ObjectQualifier = objProvider.Attributes["objectQualifier"]; if (ObjectQualifier != "" && ObjectQualifier.EndsWith("_") == false) { ObjectQualifier += "_"; } DatabaseOwner = objProvider.Attributes["databaseOwner"]; if (DatabaseOwner != "" && DatabaseOwner.EndsWith(".") == false) { DatabaseOwner += "."; } }
/// <summary> /// Seeds data when used /// </summary> public void StartUpData() { var customer = new Customer { Customer_First_Name = "Alexander", Customer_Last_Name = "Haglund", Gender = "Male", Phone_number = 9009111, E_mail = "*****@*****.**" }; var customer1 = new Customer { Customer_First_Name = "Mel", Customer_Last_Name = "Gibson", Gender = "Male", Phone_number = 7010202, E_mail = "*****@*****.**" }; var customer2 = new Customer { Customer_First_Name = "Miriam", Customer_Last_Name = "Bryant", Gender = "Female", Phone_number = 1032111, E_mail = "*****@*****.**" }; var customer3 = new Customer { Customer_First_Name = "Tobias", Customer_Last_Name = "Nilsson", Gender = "Male", Phone_number = 1212120, E_mail = "*****@*****.**" }; var customer4 = new Customer { Customer_First_Name = "Elin", Customer_Last_Name = "Rosblad", Gender = "Female", Phone_number = 2024111, E_mail = "*****@*****.**" }; var customer5 = new Customer { Customer_First_Name = "Maria", Customer_Last_Name = "Bergsten", Gender = "Female", Phone_number = 1122334, E_mail = "*****@*****.**" }; var bicycleBrand = new Bicycle_brand { Bicycle_type = "BMX", Bicycle_name = "Tricky Ramp Bike", Avilability = true }; var bicycleBrand1 = new Bicycle_brand { Bicycle_type = "Mountain Bike", Bicycle_name = "Down Hill 2000", Avilability = true }; var bicycleBrand2 = new Bicycle_brand { Bicycle_type = "Road bike", Bicycle_name = "Smooth Rider", Avilability = true }; var bicycleBrand3 = new Bicycle_brand { Bicycle_type = "Folding bikes", Bicycle_name = "Smart Bike", Avilability = true }; var bicycle = new Bicycle { Frame_number = 1313, Brand_id = 1 }; var bicycle1 = new Bicycle { Frame_number = 2121, Brand_id = 1 }; var bicycle2 = new Bicycle { Frame_number = 1111, Brand_id = 1 }; var bicycle3 = new Bicycle { Frame_number = 3131, Brand_id = 2 }; var bicycle4 = new Bicycle { Frame_number = 6262, Brand_id = 2 }; var bicycle5 = new Bicycle { Frame_number = 5757, Brand_id = 3 }; var bicycle6 = new Bicycle { Frame_number = 7811, Brand_id = 3 }; var bicycle7 = new Bicycle { Frame_number = 1100, Brand_id = 4 }; var bicycle8 = new Bicycle { Frame_number = 8811, Brand_id = 4 }; var bookingDetail = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(12), Rental_price = 1200, Customer_id = 1, Bicycle_id = 2 }; var bookingDetail1 = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(10), Rental_price = 999, Customer_id = 2, Bicycle_id = 1 }; var bookingDetail2 = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(20), Rental_price = 2000, Customer_id = 3, Bicycle_id = 3 }; var bookingDetail3 = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(5), Rental_price = 79, Customer_id = 4, Bicycle_id = 2 }; var bookingDetail4 = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(8), Rental_price = 88, Customer_id = 5, Bicycle_id = 4 }; var bookingDetail5 = new Booking_detail { Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(4), Rental_price = 49, Customer_id = 6, Bicycle_id = 4 }; var databaseOwner = new DatabaseOwner { OwnersFirstName = "Pontus", OwnersLastName = "Haglund" }; _bicycleRentalDbContext.Customers.Add(customer); _bicycleRentalDbContext.Customers.Add(customer1); _bicycleRentalDbContext.Customers.Add(customer2); _bicycleRentalDbContext.Customers.Add(customer3); _bicycleRentalDbContext.Customers.Add(customer4); _bicycleRentalDbContext.Customers.Add(customer5); _bicycleRentalDbContext.SaveChanges(); _bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand); _bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand1); _bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand2); _bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand3); _bicycleRentalDbContext.SaveChanges(); _bicycleRentalDbContext.Bicycles.Add(bicycle); _bicycleRentalDbContext.Bicycles.Add(bicycle1); _bicycleRentalDbContext.Bicycles.Add(bicycle2); _bicycleRentalDbContext.Bicycles.Add(bicycle3); _bicycleRentalDbContext.Bicycles.Add(bicycle4); _bicycleRentalDbContext.Bicycles.Add(bicycle5); _bicycleRentalDbContext.Bicycles.Add(bicycle6); _bicycleRentalDbContext.Bicycles.Add(bicycle7); _bicycleRentalDbContext.Bicycles.Add(bicycle8); _bicycleRentalDbContext.SaveChanges(); _bicycleRentalDbContext.Booking_details.Add(bookingDetail); _bicycleRentalDbContext.Booking_details.Add(bookingDetail1); _bicycleRentalDbContext.Booking_details.Add(bookingDetail2); _bicycleRentalDbContext.Booking_details.Add(bookingDetail3); _bicycleRentalDbContext.Booking_details.Add(bookingDetail4); _bicycleRentalDbContext.Booking_details.Add(bookingDetail5); _bicycleRentalDbContext.SaveChanges(); _bicycleRentalDbContext.DatabaseOwners.Add(databaseOwner); _bicycleRentalDbContext.SaveChanges(); Console.WriteLine("Database filled with information successfully"); }