/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
/// <param name="connectionString">The connection string to use. This parameter can be set to null or <see cref="String.Empty" />
/// when calling this function from an initialized data provider, since in that case it will use the connection string passed to the
/// data provider.</param>
internal static void ExecuteSqlUpgradeScript(GalleryDataSchemaUpgradeScript script, string connectionString)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
string scriptLocation = String.Format(CultureInfo.InvariantCulture, "GalleryServerPro.Data.SqlCe.{0}.sqlce", script);
using (Stream stream = asm.GetManifestResourceStream(scriptLocation))
{
if (stream == null)
{
throw new ArgumentException(String.Format(CultureInfo.CurrentCulture, "Unable to find embedded resource file named {0}", scriptLocation));
}
ExecuteSqlInStream(stream, connectionString);
}
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
private static void ExecuteSqlUpgrade(GalleryDataSchemaUpgradeScript script)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
string scriptLocation = String.Format("GalleryServerPro.Data.SqlServer.{0}.sql", script);
using (System.IO.Stream stream = asm.GetManifestResourceStream(scriptLocation))
{
if (stream == null)
{
throw new ArgumentException(String.Format("Unable to find embedded resource file named {0}", scriptLocation));
}
ExecuteSqlInStream(stream);
}
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
/// <param name="connectionString">The connection string to use. This parameter can be set to null or <see cref="String.Empty" />
/// when calling this function from an initialized data provider, since in that case it will use the connection string passed to the
/// data provider.</param>
internal static void ExecuteSqlUpgradeScript(GalleryDataSchemaUpgradeScript script, string connectionString)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
string scriptLocation = String.Format(CultureInfo.InvariantCulture, "GalleryServerPro.Data.SqlCe.{0}.sql", script);
using (Stream stream = asm.GetManifestResourceStream(scriptLocation))
{
if (stream == null)
throw new ArgumentException(String.Format(CultureInfo.CurrentCulture, "Unable to find embedded resource file named {0}", scriptLocation));
ExecuteSqlInStream(stream, connectionString);
}
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
internal static void ExecuteSqlUpgradeScript(GalleryDataSchemaUpgradeScript script)
{
ExecuteSqlUpgradeScript(script, null);
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
internal static void ExecuteSqlUpgradeScript(GalleryDataSchemaUpgradeScript script)
{
ExecuteSqlUpgradeScript(script, null);
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
private static void ExecuteSqlUpgrade(GalleryDataSchemaUpgradeScript script)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
string scriptLocation = String.Format("GalleryServerPro.Data.SqlServer.{0}.sql", script);
using (System.IO.Stream stream = asm.GetManifestResourceStream(scriptLocation))
{
if (stream == null)
throw new ArgumentException(String.Format("Unable to find embedded resource file named {0}", scriptLocation));
ExecuteSqlInStream(stream);
}
}
/// <summary>
/// Executes the SQL script represented by the specified <paramref name="script"/>. The actual SQL file is stored as an
/// embedded resource in the current assembly.
/// </summary>
/// <param name="script">The script to execute. This value is used to lookup the SQL file stored as an embedded resource
/// in the current assembly.</param>
private static void ExecuteSqlUpgrade(GalleryDataSchemaUpgradeScript script)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
using (System.IO.Stream stream = asm.GetManifestResourceStream(String.Format("GalleryServerPro.Data.SQLite.{0}.sql", script)))
{
ExecuteSqlInStream(stream);
}
}
