public ClassCreator(ISqlTypeConverter sqlTypeConverter, ICSharpClassNameConverter cSharpClassNameConverter)
{
_sqlTypeConverter = sqlTypeConverter;
_cSharpClassNameConverter = cSharpClassNameConverter;
}
/// <summary>
/// Load the result of an Sql query into the metadatas object.
/// </summary>
/// <param name="reader">Result of an Sql query defined in <see cref="MetadataProvider.SqlGetColumns"/></param>
/// <param name="metadata">Metadatas container</param>
/// <param name="serverId">ServerId loaded from</param>
/// <param name="database">Database loaded from</param>
/// <param name="typeConverter">Classe performing type conversion between database and .NET.</param>
internal static void LoadColumns(IDataReader reader, Metadatas metadata, string serverId, string database, ISqlTypeConverter typeConverter)
{
var schemaMetadata = new SchemaMetadata();
var lstSchemaColumn = new List <ColumnDefinition>();
string currentSchema;
if (!reader.Read())
{
return;
}
//Init first row
var previousSchema = reader.GetString(0);
var previousTable = new TableMetadata(reader.GetString(1));
//Pour chaque ligne
do
{
currentSchema = reader.GetString(0);
var currentTable = reader.GetString(1);
//Si on change de table
if (currentSchema != previousSchema || currentTable != previousTable.Name)
{
previousTable.ColumnsDefinition = lstSchemaColumn;
schemaMetadata.Add(previousTable);
lstSchemaColumn = new List <ColumnDefinition>();
previousTable = new TableMetadata(currentTable);
}
//Si on change de schema
if (currentSchema != previousSchema)
{
metadata[serverId, database, currentSchema] = schemaMetadata;
schemaMetadata = new SchemaMetadata();
}
//Ajoute la colonne
var col = new ColumnDefinition
{
Name = reader.GetString(2),
SqlType = new SqlType
{
DataType = reader.GetString(3),
Precision = reader.GetInt32(4),
Scale = reader.GetInt32(5),
IsUnsigned = reader.GetBoolean(6)
},
IsPrimary = reader.GetBoolean(7),
IsAutoIncrement = reader.GetBoolean(8)
};
col.DbType = typeConverter.ConvertFromSql(col.SqlType);
lstSchemaColumn.Add(col);
} while (reader.Read());
//Ajoute la dernière table / schema
if (lstSchemaColumn.Count > 0)
{
previousTable.ColumnsDefinition = lstSchemaColumn;
schemaMetadata.Add(previousTable);
metadata[serverId, database, currentSchema] = schemaMetadata;
}
}
public StoredProcecureMetadataRetreiver(ISqlTypeConverter sqlTypeConverter, ICSharpClassNameConverter cSharpClassNameConverter)
{
_sqlTypeConverter = sqlTypeConverter;
_cSharpClassNameConverter = cSharpClassNameConverter;
}
