public LinqPadMigrator(Func<string, DbConnection> sqlConnectionFactory, IDbmlManipulator dbmlManipulator)
{
// Add Migrators, in order of priority
// SQLCompact must be added before SQLServer (because it has a narrower CanExecute() match - used to generate correct SQLMetal command-line)
Migrators.Add(new SQLMigrator(sqlConnectionFactory));
Migrators.Add(new SQLCompactLinqMigrator(dbmlManipulator));
Migrators.Add(new SQLServerLinqMigrator(dbmlManipulator));
}
public LinqPadMigrator(Func <string, DbConnection> sqlConnectionFactory, IDbmlManipulator dbmlManipulator)
{
// Add Migrators, in order of priority
// SQLCompact must be added before SQLServer (because it has a narrower CanExecute() match - used to generate correct SQLMetal command-line)
Migrators.Add(new SQLMigrator(sqlConnectionFactory));
Migrators.Add(new SQLCompactLinqMigrator(dbmlManipulator));
Migrators.Add(new SQLServerLinqMigrator(dbmlManipulator));
}
public string GenerateDataContext_AndGetCSharpCode(string connectionString, string sqlMetalConnectionStringArg, IDbmlManipulator dbmlManipulator)
{
// Generate DBML File
var originalDBMLContents = GenerateDBMLFileContents(sqlMetalConnectionStringArg);
// Manipulate DBML File (Capitalization, CamelCase, etc.)
var dbmlContents = originalDBMLContents;
if (dbmlManipulator != null)
dbmlContents = dbmlManipulator.ManipulateDBML(originalDBMLContents);
// Store Temporary DBML File
var dbmlFilePath = FileHelper.WriteTextToFileAndGetFilePath(Guid.NewGuid() + ".xml", dbmlContents);
// Generate DataContext Source Code from DBML File
var dataContextSource = GenerateCSharpDataContextFromDBMLFile(dbmlFilePath, connectionString);
return dataContextSource;
}
public SQLServerLinqMigrator(IDbmlManipulator manipulator)
: base(manipulator)
{
}
static void Main(string[] args)
{
var options = new GeniusCode.Components.Console.Support.RequiredValuesOptionSet();
var connectionString = options.AddRequiredVariable <string>("conn", "Connection string to use for Linq To SQL.");
var relativeDirectory = options.AddRequiredVariable <string>("folder", "Folder that contains .SQL and .LINQ files for database migration.");
var capitalizePropertyNames = options.AddRequiredVariable <bool>("capitalize", "Capitalize Property Names, otherwise leave property same as column name.");
var console = new GeniusCode.Components.Console.ConsoleManager(options, "LinqPadMigrations");
bool success = console.PerformCanProceed(System.Console.Out, args);
if (success)
{
IDbmlManipulator dbmlManipulator = null;
// DBML Manipulator to use.
// TODO: Add command line option to not need any manipulator (by passing null to LinqPadMigrator)
if (capitalizePropertyNames.Value)
{
dbmlManipulator = new CapitalizePropertyNames();
}
else
{
dbmlManipulator = new PreserveColumnNameCasing();
}
var migrator = new LinqPadMigrator(dbmlManipulator);
var directory = relativeDirectory.Value;
if (Path.IsPathRooted(directory) == false)
{
// Make absolute using command prompt's working directory
var workingDirectory = Directory.GetCurrentDirectory(); //Environment.CurrentDirectory
directory = Path.Combine(workingDirectory, relativeDirectory.Value);
}
System.Console.Out.WriteLine("-----------------------------");
System.Console.Out.WriteLine("Folder: " + directory);
System.Console.Out.WriteLine("Connn: " + connectionString.Value);
System.Console.Out.WriteLine("-----------------------------");
if (!Directory.Exists(directory))
{
System.Console.Out.WriteLine("Directory for migration files does not exist.");
}
else
{
var filePaths = (from filePath in Directory.GetFiles(directory)
where filePath.ToUpper().EndsWith(".SQL") || filePath.ToUpper().EndsWith(".LINQ")
orderby filePath ascending
select filePath).ToList();
if (filePaths.Count() > 0)
{
System.Console.Out.WriteLine("Executing Migrations...");
Action <string> beforeScript = (scriptFilePath) =>
{
var scriptFileName = Path.GetFileName(scriptFilePath);
System.Console.Out.Write(scriptFileName + " ... ");
};
Action <MigrationResult> afterScript = (result) =>
{
if (result.Success)
{
System.Console.Out.WriteLine("Completed Successfully.");
}
else
{
System.Console.Out.WriteLine("Completed with Errors.");
}
};
try
{
var result = migrator.ExecuteMigrations(connectionString.Value, filePaths, beforeScript, afterScript);
var fileCount = result.Results.Count();
if (filePaths.Count() == fileCount)
{
System.Console.Out.WriteLine(string.Format("Migration of {0} files Succeeded.", fileCount));
}
else
{
System.Console.Out.WriteLine(string.Format("Migration completed, but the number of files processed ({0}) did not match the number of .SQL / .LINQ files in the specified directory ({1})", fileCount, filePaths.Count()));
}
}
catch (Exception ex)
{
System.Console.Out.WriteLine("Migration Failed - An exception occurred. {0}; {1}", ex.Message, ex.ToString());
}
}
else
{
System.Console.Out.WriteLine("Migration Failed - No .SQL or .LINQ files were found in specified directory.");
}
}
}
}
public SQLCompactLinqMigrator(IDbmlManipulator manipulator)
: base(manipulator)
{
}
public LinqPadMigrator(IDbmlManipulator dbmlManipulator)
: this((connectionString) => new SqlConnection(connectionString), dbmlManipulator)
{
}
public LinqPadMigrator(IDbmlManipulator dbmlManipulator)
: this((connectionString) => new SqlConnection(connectionString), dbmlManipulator)
{
}
protected LinqMigratorBase(IDbmlManipulator manipulator)
{
dbmlManipulator = manipulator;
}
public SQLCompactLinqMigrator(IDbmlManipulator manipulator)
: base(manipulator)
{
}
public SQLServerLinqMigrator(IDbmlManipulator manipulator)
: base(manipulator)
{
}
public string GenerateDataContext_AndGetCSharpCode(string connectionString, string sqlMetalConnectionStringArg, IDbmlManipulator dbmlManipulator)
{
// Generate DBML File
var originalDBMLContents = GenerateDBMLFileContents(sqlMetalConnectionStringArg);
// Manipulate DBML File (Capitalization, CamelCase, etc.)
var dbmlContents = originalDBMLContents;
if (dbmlManipulator != null)
{
dbmlContents = dbmlManipulator.ManipulateDBML(originalDBMLContents);
}
// Store Temporary DBML File
var dbmlFilePath = FileHelper.WriteTextToFileAndGetFilePath(Guid.NewGuid() + ".xml", dbmlContents);
// Generate DataContext Source Code from DBML File
var dataContextSource = GenerateCSharpDataContextFromDBMLFile(dbmlFilePath, connectionString);
return(dataContextSource);
}
