public override Tables ReadSchema(Regex tableFilterExclude, Regex columnFilterExclude, bool useCamelCase, bool prependSchemaName, bool includeComments, ExtendedPropertyCommentsStyle includeExtendedPropertyComments, Func <string, string, string> tableRename, string schemaNameFilter, Func <Column, Table, Column> updateColumn)
{
var result = new Tables();
if (Cmd == null)
{
return(result);
}
Cmd.CommandText = TableSQL;
if (Cmd.GetType().Name == "SqlCeCommand")
{
Cmd.CommandText = string.Empty;
}
else
{
Cmd.CommandTimeout = 600;
}
using (DbDataReader rdr = Cmd.ExecuteReader())
{
var rxClean = new Regex("^(event|Equals|GetHashCode|GetType|ToString|repo|Save|IsNew|Insert|Update|Delete|Exists|SingleOrDefault|Single|First|FirstOrDefault|Fetch|Page|Query)$");
var lastTable = string.Empty;
Table table = null;
while (rdr.Read())
{
string tableName = rdr["TABLENAME"].ToString().Trim();
if (tableFilterExclude != null && tableFilterExclude.IsMatch(tableName))
{
continue;
}
string schema = rdr["SCHEMANAME"].ToString().Trim();
if (schemaNameFilter != null && !schema.Equals(schemaNameFilter, StringComparison.CurrentCultureIgnoreCase))
{
continue;
}
if (lastTable != tableName || table == null)
{
// The data from the database is not sorted
table = result.Find(x => x.Name == tableName && x.Schema == schema);
if (table == null)
{
table = new Table
{
Name = tableName,
Schema = schema,
IsView = String.Compare(rdr["TABLETYPE"].ToString().Trim(), "View", StringComparison.OrdinalIgnoreCase) == 0,
// Will be set later
HasForeignKey = false,
HasNullableColumns = false
};
tableName = tableRename(tableName, schema);
CodeFirstTools.SchemaName = schema;
table.CleanName = CodeFirstTools.CleanUp(tableName);
table.ClassName = Inflector.MakeSingular(table.CleanName);
string singular = Inflector.MakeSingular(tableName);
table.NameHumanCase = (useCamelCase ? Inflector.ToTitleCase(singular) : singular).Replace(" ", "").Replace("$", "");
//if ((string.Compare(table.Schema, "dbo", StringComparison.OrdinalIgnoreCase) != 0) && prependSchemaName)
// table.NameHumanCase = table.Schema + "_" + table.NameHumanCase;
// Check for table or C# name clashes
if (CodeFirstTools.ReservedKeywords.Contains(table.NameHumanCase) ||
(useCamelCase && result.Find(x => x.NameHumanCase == table.NameHumanCase) != null))
{
table.NameHumanCase += "1";
}
result.Add(table);
}
}
var col = CreateColumn(rdr, rxClean, table, useCamelCase, columnFilterExclude, updateColumn);
if (col != null)
{
table.Columns.Add(col);
}
}
}
// Check for property name clashes in columns
foreach (Column c in result.SelectMany(tbl => tbl.Columns.Where(c => tbl.Columns.FindAll(x => x.PropertyNameHumanCase == c.PropertyNameHumanCase).Count > 1)))
{
c.PropertyNameHumanCase = c.PropertyName;
}
if (includeExtendedPropertyComments != ExtendedPropertyCommentsStyle.None)
{
ReadExtendedProperties(result);
}
ReadUniqueIndexes(result);
foreach (Table tbl in result)
{
tbl.Columns.ForEach(x => x.SetupEntityAndConfig(includeComments, includeExtendedPropertyComments));
}
return(result);
}
