public void InsertFileFieldValues(SqlConnection sqlConnection, IEnumerable <FileFieldValue> values)
{
var tableName = "FileFieldValues";
var bufferSize = 5000;
var inserter = new BulkInserter <FileFieldValue>(sqlConnection, tableName, bufferSize);
inserter.Insert(values);
}
private static void BulkInsert(IEnumerable<Stat> stats)
{
using (var ctx = new Context())
{
using (var conn = new SqlConnection(ctx.Database.Connection.ConnectionString))
{
conn.Open();
var inserter = new BulkInserter<Stat>(conn, "Stats");
inserter.Insert(stats);
}
}
}
public StockQuotesMigrationFromCsv(ILogger logger,
IDirectoryService directoryStocksReader,
IUnzipper unzipper,
IStocksBulkDeserializer stocksBulkDeserializer,
IDatabaseManagementService databaseManagementService,
BulkInserter <Company> companyBulkInserter)
{
_logger = logger;
_directoryStocksReader = directoryStocksReader;
_unzipper = unzipper;
_stocksBulkDeserializer = stocksBulkDeserializer;
_databaseManagementService = databaseManagementService;
_companyBulkInserter = companyBulkInserter;
}
public static void Write(List<LogEntry> logs)
{
using (var ctx = new Context())
{
Output.BlankLine();
Output.Write("Escrevendo registros no banco... ");
var tableName = "LogEntries";
var bufferSize = 5000;
using (var conn = new SqlConnection(ctx.Database.Connection.ConnectionString))
{
conn.Open();
var inserter = new BulkInserter<LogEntry>(conn, tableName, bufferSize);
inserter.PostBulkInsert += (sender, args) => Output.Write((logs.Count - args.Items.Count()) + " itens restantes... ");
inserter.Insert(logs);
}
Output.WriteLine(" concluído.");
}
}
public void BulkInsertTable()
{
using (Transaction tr = new Transaction())
{
var max = Database.Query <NoteWithDateEntity>().Select(a => a.Id).ToList().Max();
var list = Database.Query <AlbumEntity>().Select(a => new NoteWithDateEntity
{
CreationTime = DateTime.Now,
Text = "Nice album " + a.Name,
Target = a
}).ToList();
BulkInserter.BulkInsertTable(list);
Database.Query <NoteWithDateEntity>().Where(a => a.Id > max).UnsafeDelete();
tr.Commit();
}
}
public void Test1()
{
const string table = "IP2.Location";
using (var conn = new SqlConnection("server=.;database=afsx;integrated security=true"))
using (conn.Connect())
{
const SqlBulkCopyOptions opts = SqlBulkCopyOptions.KeepNulls;
using (var bi = new BulkInserter <Record>(conn, table, copyOptions: opts, bufferSize: 20000))
{
conn.ExecuteSql($"TRUNCATE TABLE {table}");
using (
var reader =
new StreamReader(
@"C:\dev\webbanking\download\IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE.CSV"))
{
var records = from rec in reader.ReadCsv()
select new Record
{
IpFrom = Convert.ToInt64(rec[0]),
IpTo = Convert.ToInt64(rec[1]),
CountryCode = rec[2],
CountryName = rec[3],
Region = rec[4],
City = rec[5],
Latitude = rec[6].ConvertTo <decimal?>(),
Longitude = rec[7].ConvertTo <decimal?>(),
ZipCode = rec[8]
};
bi.PostBulkInsert += (sender, args) => Console.WriteLine(args.Items.Length);
bi.Insert(records);
}
}
}
}
public void BulkInsertMList()
{
using (Transaction tr = new Transaction())
{
var max = Database.MListQuery((AlbumEntity a) => a.Songs).Max(a => a.RowId);
var list = Database.Query <AlbumEntity>().Select(a => new MListElement <AlbumEntity, SongEmbedded>
{
Parent = a,
Element = new SongEmbedded {
Duration = TimeSpan.FromMinutes(1), Name = "Bonus - " + a.Name
},
Order = 100,
}).ToList();
BulkInserter.BulkInsertMListTable((AlbumEntity a) => a.Songs, list);
Database.MListQuery((AlbumEntity a) => a.Songs).Where(a => a.RowId > max).UnsafeDeleteMList();
tr.Commit();
}
}
public void Test1()
{
const string table = "IP2.Location";
using (var conn = new SqlConnection("server=.;database=afsx;integrated security=true"))
using(conn.Connect())
{
const SqlBulkCopyOptions opts = SqlBulkCopyOptions.KeepNulls;
using (var bi = new BulkInserter<Record>(conn, table, copyOptions: opts, bufferSize:20000))
{
conn.ExecuteSql($"TRUNCATE TABLE {table}");
using (
var reader =
new StreamReader(
@"C:\dev\webbanking\download\IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE.CSV"))
{
var records = from rec in reader.ReadCsv()
select new Record
{
IpFrom = Convert.ToInt64(rec[0]),
IpTo = Convert.ToInt64(rec[1]),
CountryCode = rec[2],
CountryName = rec[3],
Region = rec[4],
City = rec[5],
Latitude = rec[6].ConvertTo<decimal?>(),
Longitude = rec[7].ConvertTo<decimal?>(),
ZipCode = rec[8]
};
bi.PostBulkInsert += (sender, args) => Console.WriteLine(args.Items.Length);
bi.Insert(records);
}
}
}
}
