private string GetQuery(string QueryText, DatabaseMapping Mapping) { foreach (var m in MappingsProvider.GetGlobalNames()) { //Using regex replace so that the case doesn't need to match QueryText = Regex.Replace(QueryText, m, Mapping.GetLocalName(m), RegexOptions.IgnoreCase); } return(QueryText); }
public static List <DatabaseMapping> GetMappings() { List <DatabaseMapping> DbMappings = new List <DatabaseMapping>(); //Initialise Database 1 DatabaseMapping Db1 = new DatabaseMapping(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Ali\Downloads\Project1\Database2.mdf;Integrated Security=True"); //Db1 Tables Db1.AddTableMapping("Cars", "Cars"); Db1.AddTableMapping("Customers", "Customer"); Db1.AddTableMapping("Rentals", "Rentals"); //Cars Columns Db1.AddColumnMapping("Cars", "G-Vin", "VinNum"); Db1.AddColumnMapping("Cars", "G-Make", "Maker"); Db1.AddColumnMapping("Cars", "G-Year", "Year"); Db1.AddColumnMapping("Cars", "G-Type", "NULL AS [Type]"); Db1.AddColumnMapping("Cars", "G-Color", "Color"); Db1.AddColumnMapping("Cars", "G-NumOfPassengers", "NumOfPasger"); Db1.AddColumnMapping("Cars", "G-Price", "DailyRentalPrice"); //Customers Columns Db1.AddColumnMapping("Customers", "G-License", "License"); Db1.AddColumnMapping("Customers", "G-FullName", "FirstName + ' ' + MiddleName + ' ' + LastName AS [full_name]"); Db1.AddColumnMapping("Customers", "G-FullAddress", "Street + ', ' + City + ', ' + State + ', ' + ZipCode AS [full_address]"); Db1.AddColumnMapping("Customers", "G-Age", "NULL AS [Age]"); //Rentals Columns Db1.AddColumnMapping("Rentals", "G-Vin", "VinNum"); Db1.AddColumnMapping("Rentals", "G-License", "License"); Db1.AddColumnMapping("Rentals", "G-StartDate", "CAST(StartRentDate AS DATE) AS [StartDate]"); Db1.AddColumnMapping("Rentals", "G-NumberOfDays", "DATEDIFF(DAY,CAST(StartRentDate AS DATE),CAST(EndDate AS DATE)) AS [NumberOfDays]"); Db1.AddColumnMapping("Rentals", "G-Discount", "Discount"); DbMappings.Add(Db1); //Initialise Database 1 DatabaseMapping Db2 = new DatabaseMapping(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Ali\Downloads\Project1\Database1.mdf;Integrated Security=True"); //Db2 Tables Db2.AddTableMapping("Cars", "Cars"); Db2.AddTableMapping("Customers", "Customers"); Db2.AddTableMapping("Rentals", "Rentals"); //Cars Columns Db2.AddColumnMapping("Cars", "G-Vin", "Vin"); Db2.AddColumnMapping("Cars", "G-Make", "NULL AS [Make]"); Db2.AddColumnMapping("Cars", "G-Year", "CAST(Year AS VARCHAR(10)) AS [Year]"); Db2.AddColumnMapping("Cars", "G-Type", "Type"); Db2.AddColumnMapping("Cars", "G-Color", "NULL AS [Color]"); Db2.AddColumnMapping("Cars", "G-NumOfPassengers", "NULL AS [NumberOfPassengers]"); Db2.AddColumnMapping("Cars", "G-Price", "Price"); //Customers Columns Db2.AddColumnMapping("Customers", "G-License", "Drivers_License"); Db2.AddColumnMapping("Customers", "G-FullName", "Full_name"); Db2.AddColumnMapping("Customers", "G-FullAddress", "Full_Address"); Db2.AddColumnMapping("Customers", "G-Age", "DATEDIFF(YEAR, DOB,GETDATE()) AS [Age]"); //Rentals Columns Db2.AddColumnMapping("Rentals", "G-Vin", "Vin"); Db2.AddColumnMapping("Rentals", "G-License", "Drivers_License"); Db2.AddColumnMapping("Rentals", "G-StartDate", "Start_Rental_Date"); Db2.AddColumnMapping("Rentals", "G-NumberOfDays", "DATEDIFF(DAY,start_rental_date,end_rental_date) AS [NumberOfDays]"); Db2.AddColumnMapping("Rentals", "G-Discount", "NULL AS [Discount]"); DbMappings.Add(Db2); //Return return(DbMappings); }
private void AddDbMapping(DatabaseMapping Mapping) { DbMappings.Add(Mapping); }