public bool IsAllFieldValid(Type type)
{
DbRecordInfo info = DbAttributesManager.GetRecordInfo(type);
Dictionary <string, string> fields = accessor.LoadFields(info.TableName);
if (fields.Count == 0)
{
throw new NdbException("Unable to load fields for the following table: " + info.TableName);
}
DbFieldCheckResult checker = new DbFieldCheckResult(accessor);
foreach (DbFieldInfo fi in info.Fields)
{
checker.Process(fields, fi);
if (checker.IsNew)
{
LastError = string.Format("{0} in {1} ({2}) isn't present in db"
, fi.Name, type, fi.FieldType);
return(false);
}
if (checker.IsDifferent)
{
LastError = string.Format("{0} in {1} is {2} but column is {3}"
, fi.Name, type, fi.FieldType, checker.CurrentSqlType);
return(false);
}
}
return(true);
}
public void Build(Type type)
{
DbRecordInfo info = DbAttributesManager.GetRecordInfo(type);
TableName = info.TableName;
Dictionary <string, string> fields = accessor.LoadFields(TableName);
FieldsToCreate = new Dictionary <string, string>();
FieldsToUpdate = new Dictionary <string, string>();
DbFieldCheckResult checker = new DbFieldCheckResult(accessor);
foreach (DbFieldInfo fi in info.Fields)
{
checker.Process(fields, fi);
if (checker.IsNew)
{
FieldsToCreate.Add(fi.Name, checker.SqlType);
}
else
if (checker.IsDifferent)
{
FieldsToUpdate.Add(fi.Name, checker.SqlType);
}
}
}