public static IDbConnection GetDbConnection(IDataSourceDb databse)
{
IDbConnection connection = null;
switch (databse.DBTYPE)
{
case DataBaseType.SqlServer:
connection = new SqlConnection();
break;
case DataBaseType.MySql:
case DataBaseType.Sqlite:
connection = databse.GetNewConnection(false, true);
break;
case DataBaseType.Oracle:
break;
case DataBaseType.Oledb:
#if NETFRAMEWORK
connection = new OleDbConnection();
break;
#else
throw new NotImplementedException($@".Net Standard haven't implemented this functionality yet.");
#endif
case DataBaseType.Access95:
#if NETFRAMEWORK
connection = new OleDbConnection();
break;
#else
throw new NotImplementedException($@".Net Standard haven't implemented this functionality yet.");
#endif
case DataBaseType.Odbc:
#if NETFRAMEWORK
connection = new OdbcConnection();
break;
#else
throw new NotImplementedException($@".Net Standard haven't implemented this functionality yet.");
#endif
default:
throw new ArgumentOutOfRangeException();
}
if (connection != null)
{
connection.ConnectionString = databse.BuildConnectionString();
}
return(connection);
}
/// <summary>
/// Bulks the insert.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="listPoco">The list poco.</param>
/// <param name="tableName">Name of the table.</param>
/// <returns>System.Int32.</returns>
private static int BulkInsertSqlServer <T>(IDataSourceDb database, IEnumerable <T> listPoco, string tableName) where T : class
{
using (var bcp = new SqlBulkCopy(database.BuildConnectionString()))
{
var openTime = DateTime.Now;
var bucket = new QueryBucket()
{
Query = $"Bulk Insert On List Of Type {typeof(T).Name} Into Table {tableName}",
Server = database.Server,
DatabaseType = database.DBTYPE.ToString()
};
bcp.SqlRowsCopied += delegate(object sender, SqlRowsCopiedEventArgs args)
{
bucket.ConnectionDisposeTime = DateTime.Now;
};
database.QueryBucketManager.AddBucket(bucket);
var array = new List <string>()
{
};
var advances = ExtFastMember.GetAdvanceMembers(listPoco.FirstOrDefault()).Where(m => m.SqlCustomAttritube.AutoIncrementBy == null && m.SqlCustomAttritube.StartIncrementAt == null && m.SqlCustomAttritube.Ignore != true).ToList(); // EXECLUDES IDENTITY FEILDS
advances.ForEach(delegate(AdvanceMember member)
{
var columnName = member.SqlCustomAttritube.MapTo ?? member.Member.Name;
array.Add(columnName);
});
using (var reader = ObjectReader.Create(listPoco, array.ToArray()))
{
bcp.DestinationTableName = tableName;
bcp.BulkCopyTimeout = database.Timeout.TotalSeconds.ToInt(false);
bcp.WriteToServer(reader);
return(listPoco.Count());
}
}
}