static public DataTable GetInstance (SqlConnection conn)
{
DataTable table = new DataTable ("DataSourceInformation");
foreach (ColumnInfo c in columns)
table.Columns.Add (c.name, c.type);
DataRow row = table.NewRow ();
row [0] = "\\.";
row [1] = "Microsoft SQL Server";
row [2] = conn.ServerVersion;;
row [3] = conn.ServerVersion;;
row [4] = GroupByBehavior.Unrelated;
row [5] = @"(^\[\p{Lo}\p{Lu}\p{Ll}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Nd}@$#_]*$)|(^\[[^\]\0]|\]\]+\]$)|(^\""[^\""\0]|\""\""+\""$)";
row [6] = IdentifierCase.Insensitive; // FIXME: obtain this from SQL Server
row [7] = false;
row [8] = "{0}";
row [9] = @"@[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$)";
row [10] = 128;
row [11] = @"^[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$)";
row [12] = @"(([^\[]|\]\])*)";
row [13] = IdentifierCase.Insensitive; // FIXME: obtain this from SQL Server
row [14] =";";
row [15] = "'(([^']|'')*)'";
row [16] = (SupportedJoinOperators.FullOuter | SupportedJoinOperators.Inner |
SupportedJoinOperators.LeftOuter | SupportedJoinOperators.RightOuter);
table.Rows.Add (row);
return table;
}
}