private void ExecuteBulkInsert(FileDataReader dr)
{
var cstr = Test.Constants.TestConnectionString;
var dropsql = "IF OBJECT_ID('testtable','U') IS NOT NULL DROP TABLE testtable";
var createsql = "CREATE TABLE testtable (one int, two int, three int)";
using (var cn = new SqlConnection(cstr))
{
cn.Open();
// Drop table first
using (var cmd = new SqlCommand(dropsql, cn))
{
cmd.ExecuteNonQuery();
}
// Create empty table
using (var cmd = new SqlCommand(createsql, cn))
{
cmd.ExecuteNonQuery();
}
// Run bulk-insert
var bcp = new SqlBulkCopy(cn);
bcp.DestinationTableName = "testtable";
bcp.WriteToServer(dr);
// Drop table
using (var cmd = new SqlCommand(dropsql, cn))
{
cmd.ExecuteNonQuery();
}
}
}
private void ExecuteBulkInsert(FileDataReader dr)
{
var cstr = Jhu.Graywulf.Test.AppSettings.IOTestConnectionString;
var dropsql = "IF OBJECT_ID('testtable','U') IS NOT NULL DROP TABLE testtable";
var createsql = "CREATE TABLE testtable (one int, two int, three int)";
using (var cn = new SqlConnection(cstr))
{
cn.Open();
// Drop table first
using (var cmd = new SqlCommand(dropsql, cn))
{
cmd.ExecuteNonQuery();
}
// Create empty table
using (var cmd = new SqlCommand(createsql, cn))
{
cmd.ExecuteNonQuery();
}
// Run bulk-insert
var bcp = new SqlBulkCopy(cn);
bcp.DestinationTableName = "testtable";
bcp.WriteToServer(dr);
// Drop table
using (var cmd = new SqlCommand(dropsql, cn))
{
cmd.ExecuteNonQuery();
}
}
}
public void Dispose()
{
if (dataReader != null)
{
dataReader.Dispose();
dataReader = null;
}
}
public FileDataReader ExecuteReader(CommandBehavior behavior)
{
dataReader = new FileDataReader(file);
return(dataReader);
}
private void InitializeMembers()
{
this.file = null;
this.dataReader = null;
}
public void Dispose()
{
if (dataReader != null)
{
dataReader.Dispose();
dataReader = null;
}
}
private void InitializeMembers()
{
this.file = null;
this.dataReader = null;
}
public FileDataReader ExecuteReader(CommandBehavior behavior)
{
dataReader = new FileDataReader(file);
return dataReader;
}