private void SetDbParams(System.Data.Common.DbConnection conn)
{
if (conn.GetType().Name.ToLower().IndexOf("oracle") > -1 || conn.GetType().Name.ToLower().IndexOf("pgsql") > -1)
{
dbParamChar = ':';
}
}
public static string GenerateAllTables(this System.Data.Common.DbConnection connection, GeneratorBehavior generatorBehavior = GeneratorBehavior.Default)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var conneciontName = connection.GetType().Name.ToLower();
var tables = new List <string>();
var sql = generatorBehavior.HasFlag(GeneratorBehavior.View) ? TableSchemaSqls[conneciontName].Split("where")[0] : TableSchemaSqls[conneciontName];
using (var command = connection.CreateCommand(sql))
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tables.Add(reader.GetString(0));
}
}
var sb = new StringBuilder();
sb.AppendLine("namespace Models { ");
tables.ForEach(table => sb.Append(connection.GenerateClass(
string.Format(QuerySqls[conneciontName], table), table, generatorBehavior: generatorBehavior
)));
sb.AppendLine("}");
return(sb.ToString());
}
public SchemaParameters(System.Data.Common.DbConnection dbConnection)
{
DbConnection = dbConnection;
ProviderName = DbConnection.GetType().Namespace;
ConnectionString = dbConnection.ConnectionString;
SqlType = ProviderToSqlType.Convert(ProviderName);
Exclusions = new Exclusions();
}
private static ISqlAdapter GetFormatter(IDbConnection connection)
{
var name = GetDatabaseType?.Invoke(connection).ToLower()
?? connection.GetType().Name.ToLower();
return(!AdapterDictionary.ContainsKey(name)
? DefaultAdapter
: AdapterDictionary[name]);
}
/// <summary>
/// Gets the feature set based on the passed connection
/// </summary>
public static FeatureSupport Get(IDbConnection connection)
{
string name = connection?.GetType().Name;
if (string.Equals(name, "npgsqlconnection", StringComparison.OrdinalIgnoreCase))
{
return(Postgres);
}
return(Default);
}
} // End Static Constructor
public static System.Data.Common.DbProviderFactory GetProviderByReflection(System.Data.Common.DbConnection conn)
{
System.Type t = conn.GetType();
System.Reflection.PropertyInfo pi = t.GetProperty("DbProviderFactory",
System.Reflection.BindingFlags.NonPublic
| System.Reflection.BindingFlags.Instance
);
return((System.Data.Common.DbProviderFactory)pi.GetValue(conn));
} // End Function GetProviderByReflection
/// <summary>
/// Initializes a new instance of the <see cref="DatabaseReader"/> class from a DbConnection.
/// </summary>
/// <param name="connection">The connection.</param>
public DatabaseReader(System.Data.Common.DbConnection connection)
{
var name = connection.GetType().Namespace;
_db = new DatabaseSchema(connection.ConnectionString, name);
_schemaParameters = new SchemaParameters(connection)
{
DatabaseSchema = _db
};
_readerAdapter = ReaderAdapterFactory.Create(_schemaParameters);
}
/// <summary>
/// Initializes a new instance of the <see cref="DatabaseReader"/> class from a DbConnection.
/// </summary>
/// <param name="connection">The connection.</param>
public DatabaseReader(System.Data.Common.DbConnection connection) :
this(connection.GetType().Namespace, connection.ConnectionString, new SchemaParameters(connection))
{
}