public static int GenerateRows(StreamWriter writer, TableSchema schema, Locator where, bool hasIfExists)
{
TableName tableName = schema.TableName;
string sql = string.Format("SELECT * FROM {0}", tableName);
if (where != null)
sql = string.Format("SELECT * FROM {0} WHERE {1}", tableName, where);
SqlCmd cmd = new SqlCmd(tableName.Provider, sql);
TableClause script = new TableClause(schema);
int count = 0;
cmd.Read(
reader =>
{
DataTable schema1 = reader.GetSchemaTable();
string[] columns = schema1.AsEnumerable().Select(row => row.Field<string>("ColumnName")).ToArray();
object[] values = new object[columns.Length];
while (reader.HasRows)
{
while (reader.Read())
{
reader.GetValues(values);
if (hasIfExists)
writer.WriteLine(script.IF_NOT_EXISTS_INSERT(columns, values));
else
writer.WriteLine(script.INSERT(columns, values));
count++;
if (count % 5000 == 0)
writer.WriteLine(TableClause.GO);
}
reader.NextResult();
}
});
if (count != 0)
writer.WriteLine(TableClause.GO);
return count;
}
