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") ); }