public void Validate(SqlServerValidationToolkitContext ctxSqlServer) { foreach (var source in Sources //include the errorType to get to the code of the wrong-values .Include( s => s.Columns .Select(c => c.ValidationRules .Select(r => r.Validation_WrongValue .Select(wv => wv.Errortype) ) ) ) ) { source.Validate(ctxSqlServer.Database.Connection, this); } SaveChanges(); this.Database.ExecuteSqlCommand("DELETE FROM Validation_WrongValue WHERE Is_Corrected=1"); }
public static SqlServerValidationToolkitContext Create() { SqlServerValidationToolkitContext ctx; if (Settings.Default.StoreMetadataInSqlServer) { ctx = SqlServerValidationToolkitContext.Create(Settings.Default.MetadataDatabaseConnectionString); } else { string databaseFileName = "SqlServerValidationToolkit.Model.Context.SqlServerValidationToolkitContext.sdf"; string sqlServerCompactConnectionString = string.Format("Data Source={0}", databaseFileName); ctx = new SqlServerValidationToolkitContext(sqlServerCompactConnectionString); if (!File.Exists(databaseFileName)) { ctx.Database.CreateIfNotExists(); } } DatabaseInitializer.AddErrorTypes(ctx); return(ctx); }