private static string GetLastDBScriptVersion(PortableAreaRegistration portableArea)
{
string[] resources = Assembly.GetAssembly(portableArea.GetType()).GetManifestResourceNames();
//eg: Appleseed.Core.DBScripts._20110413.01. Create_DBVersion_Table.sql
var dbversions = resources.Where(d => d.Contains(".sql")).Select(d => d.Substring(d.IndexOf("._") + 2, 11));
return(dbversions.OrderBy(d => d).LastOrDefault());
}
private static List <DBScriptDescriptor> GetScripts(PortableAreaRegistration portableArea)
{
string[] resources = Assembly.GetAssembly(portableArea.GetType()).GetManifestResourceNames();
var result = new List <DBScriptDescriptor>();
foreach (var resource in resources.Where(d => d.Contains(".sql")))
{
var version = resource.Substring(resource.IndexOf("._") + 2, 11).Replace(".", "_");
result.Add(new DBScriptDescriptor {
Url = resource, Version = version
});
}
return(result);
}
