Creates a table in a database.
(in Microsoft.Web.Management.DatabaseManager.dll)
Visual Basic (Declaration)
Sub CreateTable ( _
connectionString As String, _
schema As String, _
tableInfo As TableInfo _
)
Dim instance As IDbTableManager
Dim connectionString As String
Dim schema As String
Dim tableInfo As TableInfo
instance.CreateTable(connectionString, _
schema, tableInfo)
void CreateTable(
string connectionString,
string schema,
TableInfo tableInfo
)
void CreateTable(
String^ connectionString,
String^ schema,
TableInfo^ tableInfo
)
function CreateTable(
connectionString : String,
schema : String,
tableInfo : TableInfo
)
All database providers that implement the IDbTableManager interface must also implement the CreateTable method, which the database manager will use to create tables in a database.
Notes for Implementers
If your provider does not support adding tables, you can use the following code sample to raise a not-implemented exception:
public void CreateTable(string connectionString, string schema, TableInfo tableInfo)
{
throw new NotImplementedException();
}
The following code sample implements the CreateTable method for an OLEDB connection by using the TableInfo object that the database manager provides.
.gif) Note: |
|---|
This example also provides helper methods that perform additional database tasks. |
Public Sub CreateTable( _
ByVal connectionString As String, _
ByVal schema As String, _
ByVal tableInfo As TableInfo) _
Implements Microsoft.Web.Management.DatabaseManager.IDbTableManager.CreateTable
' Create a connection to the database.
Dim connection As OleDbConnection = New OleDbConnection(connectionString)
' Create a new string builder for the SQL statement.
Dim createTableText As StringBuilder = New StringBuilder
Try
' Begin the SQL statement.
createTableText.Append("CREATE TABLE ")
' Append the table name to the SQL statement.
createTableText.Append(EscapeName(tableInfo.Name))
' Begin the list of columns.
createTableText.Append(" (")
For Each column As Column In tableInfo.Columns
' Append a column name to the SQL statement.
createTableText.Append(EscapeName(column.Name))
createTableText.Append(" ")
' Append a column type to the SQL statement.
createTableText.Append(column.TypeInfo)
' Test if the column type allows nulls.
If (column.AllowNulls) Then
createTableText.Append(" NULL, ")
Else
createTableText.Append(" NOT NULL, ")
End If
Next
createTableText.Remove((createTableText.Length - 2), 2)
' End the list of columns.
createTableText.Append(")")
' Create an OLEDB command object.
Dim command As OleDbCommand = New OleDbCommand(createTableText.ToString, connection)
' Open the connection to the database.
connection.Open()
' Run the SQL statement.
command.ExecuteNonQuery()
Catch ex As Exception
' Raise an exception if an error occurs.
Throw New ProviderException(("CREATE TABLE Exception:" + vbLf + vbLf + ex.Message))
End Try
End Sub
...
Friend Shared Function EscapeName(ByVal name As String) As String
' Test if the value is already escaped.
If (name.StartsWith("[", StringComparison.Ordinal) AndAlso name.EndsWith("]", StringComparison.Ordinal)) Then
' Return the string with no changes.
Return name
End If
' Create a new string builder for the escaped string.
Dim escapedName As StringBuilder = New StringBuilder
' Prepend the string with an opening bracket.
escapedName.Append(Microsoft.VisualBasic.ChrW(91))
' Loop through the string.
Dim i As Integer = 0
Do While (i < name.Length)
Dim c As Char = name(i)
If (c = Microsoft.VisualBasic.ChrW(93)) Then
escapedName.Append(Microsoft.VisualBasic.ChrW(93))
End If
escapedName.Append(c)
i = (i + 1)
Loop
' Append the string with an opening bracket.
escapedName.Append(Microsoft.VisualBasic.ChrW(93))
' Return the escaped string.
Return escapedName.ToString
End Function
// Create a table in the database.
public void CreateTable(
string connectionString,
string schema,
TableInfo tableInfo )
{
// Create a connection to the database.
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
// Create a new string builder for the SQL statement.
StringBuilder createTableText = new StringBuilder();
try
{
// Begin the SQL statement.
createTableText.Append("CREATE TABLE ");
// Append the table name to the SQL statement.
createTableText.Append(EscapeName(tableInfo.Name));
// Begin the list of columns.
createTableText.Append(" (");
foreach (Column column in tableInfo.Columns)
{
// Append a column name to the SQL statement.
createTableText.Append(EscapeName(column.Name));
createTableText.Append(" ");
// Append a column type to the SQL statement.
createTableText.Append(column.TypeInfo);
// Test if the column type allows nulls.
createTableText.Append(column.AllowNulls ? " NOT NULL, " : " NULL, ");
}
createTableText.Remove(createTableText.Length - 2, 2);
// End the list of columns.
createTableText.Append(")");
// Create an OLEDB command object.
using (OleDbCommand command = new OleDbCommand(createTableText.ToString(), connection))
{
// Open the connection to the database.
connection.Open();
// Run the SQL statement.
command.ExecuteNonQuery();
}
}
catch(Exception ex)
{
// Raise an exception if an error occurs.
throw new ProviderException("CREATE TABLE Exception:\n\n" + ex.Message);
}
}
}
...
internal static string EscapeName(string name)
{
// Test if the value is already escaped.
if (name.StartsWith("[", StringComparison.Ordinal) && name.EndsWith("]", StringComparison.Ordinal))
{
// Return the string with no changes.
return name;
}
// Create a new string builder for the escaped string.
StringBuilder escapedName = new StringBuilder();
// Prepend the string with an opening bracket.
escapedName.Append('[');
// Loop through the string.
for (int i = 0; i < name.Length; i++)
{
char c = name[i];
if (c == ']')
{
escapedName.Append(']');
}
escapedName.Append(c);
}
// Append the string with an opening bracket.
escapedName.Append(']');
// Return the escaped string.
return escapedName.ToString();
}
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .
Reference