private string GetSqlScript(string resourceName)
{
Assembly assembly = GetType().Assembly;
var stream = assembly.GetManifestResourceStream(resourceName);
if (stream == null)
return "";
var streamReader = new StreamReader(stream);
string data = streamReader.ReadToEnd();
streamReader.Close();
return data;
}