//public static Version GetVersionInfo() { // using (Entities context = new Entities()) { // DbVersion Result = context.DbVersions.Single(); // return new Version(Result.Major, Result.Minor, Result.Build, Result.Revision); // } //} public static Version GetVersionInfo() { using (Entities context = new Entities()) { // We must query manually because querying entity objects would fail on outdated databases. DbVersion Result = context.Database.SqlQuery <DbVersion>("SELECT Major, Minor, Build, Revision FROM Version").FirstOrDefault(); return(new Version(Result.Major, Result.Minor, Result.Build, Result.Revision)); } }
public static void UpdateVersionInfo(Version version) { using (Entities context = new Entities()) { DbVersion Row = context.DbVersions.Single(); Row.Major = version.Major; Row.Minor = version.Minor; Row.Build = version.Build; Row.Revision = version.Revision; context.SaveChanges(); } }