C# Class ShpToSQL.SqlTableCreator

Exibir arquivo Open project: dknezevic/ShpToSqlServer Class Usage Examples

Public Methods

Method	Description
Create ( DataTable schema ) : object
Create ( DataTable schema, int numKeys ) : object
CreateFromDataTable ( DataTable table ) : object
GetCreateFromDataTableSQL ( string tableName, DataTable table ) : string
GetCreateSQL ( string tableName, DataTable schema, int primaryKeys ) : string
GetPrimaryKeys ( DataTable schema ) : string[]
SQLGetType ( DataColumn column ) : string
SQLGetType ( DataRow schemaRow ) : string
SQLGetType ( object type, int columnSize, int numericPrecision, int numericScale ) : string
SqlTableCreator ( ) : System
SqlTableCreator ( SqlConnection connection ) : System
SqlTableCreator ( SqlConnection connection, SqlTransaction transaction ) : System

Method Details

Create() public method

public Create ( DataTable schema ) : object
schema	System.Data.DataTable
return	object

Create() public method

public Create ( DataTable schema, int numKeys ) : object
schema	System.Data.DataTable
numKeys	int
return	object

CreateFromDataTable() public method

public CreateFromDataTable ( DataTable table ) : object
table	System.Data.DataTable
return	object

GetCreateFromDataTableSQL() public static method

public static GetCreateFromDataTableSQL ( string tableName, DataTable table ) : string
tableName	string
table	System.Data.DataTable
return	string

GetCreateSQL() public static method

public static GetCreateSQL ( string tableName, DataTable schema, int primaryKeys ) : string
tableName	string
schema	System.Data.DataTable
primaryKeys	int
return	string

GetPrimaryKeys() public static method

public static GetPrimaryKeys ( DataTable schema ) : string[]
schema	System.Data.DataTable
return	string[]

SQLGetType() public static method

public static SQLGetType ( DataColumn column ) : string
column	System.Data.DataColumn
return	string

SQLGetType() public static method

public static SQLGetType ( DataRow schemaRow ) : string
schemaRow	System.Data.DataRow
return	string

SQLGetType() public static method

public static SQLGetType ( object type, int columnSize, int numericPrecision, int numericScale ) : string
type	object
columnSize	int
numericPrecision	int
numericScale	int
return	string

SqlTableCreator() public method

public SqlTableCreator ( ) : System
return	System

SqlTableCreator() public method

public SqlTableCreator ( SqlConnection connection ) : System
connection	System.Data.SqlClient.SqlConnection
return	System

SqlTableCreator() public method

public SqlTableCreator ( SqlConnection connection, SqlTransaction transaction ) : System
connection	System.Data.SqlClient.SqlConnection
transaction	System.Data.SqlClient.SqlTransaction
return	System