DbDataReader ObtainDataReader(SqlConnection connection, string text)
{
_recordsAffected = 0;
if(_sqls.Length > 100)
return Profiler.Measure(() => connection.ToDataReader(text));
return Profiler.Measure(() => connection.ToDataReader(text));
}
SqlBatch(string server, string dataBase)
{
var connectionString = new DbConnectionStringBuilder();
connectionString["Data Source"] = server;
connectionString["Initial Catalog"] = dataBase;
connectionString["Integrated Security"] = "SSPI";
connectionString["MultipleActiveResultSets"] = true;
_connection = new SqlConnection(connectionString.ConnectionString);
_connection.Open();
const string trunc = "truncate table test\n";
const string insert = "insert into test (Id, Name) values ({0}, '{1}')";
_connection
.ToDataReader
(
trunc
+ 1.While(i => i <= 4)
.Select(i => insert.ReplaceArgs(i, "text" + i))
.Stringify("\n")
);
}
