public void SetMany <F>(IncludeTables <F, T> include, List <F> listMany) where F : class
{
FilterMayny <T, F> filterByMany = new FilterMayny <T, F>(include);
filterByMany.SetListSecondTables(listMany);
listFilters.Add(filterByMany);
}
public string Configure(string sqlTemplate, string database, string schema, string stagingDatabase)
{
var output = sqlTemplate.Replace("__DatabaseName__", database)
.Replace("__SchemaName__", schema)
.Replace("__TableNamePrefix__", TablePrefix)
.Replace("__ExcludeTables__", string.Join(",",
ExcludeTables.Where(t => t.Database.Equals(database) && t.Schema.Equals(schema)).Select(t => t.Name)))
.Replace("__IncludeTables__", string.Join(",",
IncludeTables.Where(t => t.Database.Equals(database) && t.Schema.Equals(schema)).Select(t => t.Name)))
.Replace("__StagingDatabaseName__", stagingDatabase);
return(output);
}
public override string ToString()
{
return(string.Format("Name: {0}\n\tGenerateCreateTable: {1}\n\tFilters\n\t\tDefaultSchema: {2}\n\t\tDefaultDatabase: {3}\n\tTablePrefix: {4}\n\tExcludeTables:\t{5}\n\tIncludeTables:\t{6}",
Name, GenerateCreateTable, DefaultSchema, DefaultDatabase, TablePrefix, string.Join("\n\t\t\t", ExcludeTables.Select(t => t)), string.Join("\n\t\t\t", IncludeTables.Select(t => t))));
}
public RelatedTableCommand(IncludeTables <T, A> relMethod, SearchTableFromContext <T> request, List <T> SecondTablesList)
{
this.relMethod = relMethod;
this.SecondTablesList = SecondTablesList;
this.request = request;
}
public Results Generate(SchemaModel model)
{
_model = model;
var flattener = new ModelFlattener();
model.Accept(flattener);
_tables = flattener.Tables;
_classes = flattener.Classes;
_procedures = flattener.Procedures;
_namespaces = flattener.Namespaces;
foreach (var t in _tables)
{
t.TableName = SetCasing(t.TableName);
t.Name = SetCasing(t.Name);
var className = RemoveSuffix(SetCasing(t.DataObjectClassName ?? t.TableName), "_t");
var propName = SetCasing(t.DataContextPropertyName ?? className);
if (PluralizeDataContextPropertyNames || SingularizeDataContextPropertyNames)
{
var newName = PluralizeDataContextPropertyNames ? ToPlural(propName) : ToSingular(propName);
t.DataContextPropertyName = newName;
}
else
{
t.DataContextPropertyName = SetCasing(propName);
}
if (PluralizeClassNames || SingularizeClassNames)
{
className = PluralizeClassNames ? ToPlural(className) : ToSingular(className);
}
t.DataObjectClassName = className;
if (DataObjectSuffix != null)
{
t.DataObjectClassName += DataObjectSuffix;
}
className = SetCasing(RemoveSuffix(t.PocoClassName ?? t.TableName, "_t"));
t.PocoClassName = className;
if (!PocoSuffix.IsNullOrEmpty())
{
t.PocoClassName += PocoSuffix;
}
}
if (AdapterNamespace.IsNullOrEmpty())
{
AdapterNamespace = DataNamespace;
}
DataContextName = DataContextName?.Trim();
_results = new Results();
if (string.IsNullOrEmpty(DataContextName))
{
DataContextName = "DataContext";
}
var allTables = (from t in _tables orderby t.TableName select t).ToList();
_targetTables = allTables;
if (IncludeTables != null &&
IncludeTables.Count > 0)
{
_targetTables = allTables.Where(t => IncludeTables.Contains(t.OriginalTableName)).ToList();
}
if (!IncludeTablePattern.IsNullOrEmpty())
{
if (_targetTables == null)
{
_targetTables = new List <Table>();
}
_includeTableMatcher = new Regex(IncludeTablePattern,
RegexOptions.Compiled | RegexOptions.CultureInvariant | RegexOptions.IgnoreCase);
foreach (var table in allTables)
{
if (_includeTableMatcher.IsMatch(table.OriginalTableName) &&
!_targetTables.Contains(table))
{
_targetTables.Add(table);
}
}
}
if (GeneratePocos || GenerateAdapters)
{
BuildPocoModel();
}
if (GenerateDataObjects)
{
GenerateDataObjectModels();
}
return(_results);
}
public FilterMayny(IncludeTables <A, T> bindingTables) : base()
{
this.bindingTables = bindingTables;
}
