C# Class DbDictExport.Core.Dal.DataAccess

DataAccess class for get the database data.
Mostrar archivo Open project: NeilQ/DbDictExport

Public Methods

Method Description
GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : List

Gets a list of DbColumn.
GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string tableName ) : List

Gets a list of dbColumn.
GetDbNameList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder ) : List

Gets a list of database name.
GetDbTableListWithColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List

Gets a list of dbTable.
GetDbTableNameListWithoutColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List

Gets a list of datatable name.
GetResultSetByDbTable ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : DataTable

Gets a dataTable of the top 500 columns.
GetTableByName ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName, string tableName ) : DbTable

Gets a dbTable.

Method Details

GetDbColumnList() public static method

Gets a list of DbColumn.
public static GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
table DbTable The specified dbTable. table.Name cannot be empty.
return List

GetDbColumnList() public static method

Gets a list of dbColumn.
public static GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string tableName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
tableName string The specified data table name.
return List

GetDbNameList() public static method

Gets a list of database name.
public static GetDbNameList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
return List

GetDbTableListWithColumns() public static method

Gets a list of dbTable.
public static GetDbTableListWithColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified datatable name.
return List

GetDbTableNameListWithoutColumns() public static method

Gets a list of datatable name.
public static GetDbTableNameListWithoutColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified database name.
return List

GetResultSetByDbTable() public static method

Gets a dataTable of the top 500 columns.
public static GetResultSetByDbTable ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : DataTable
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
table DbTable The specified dbTable.
return System.Data.DataTable

GetTableByName() public static method

Gets a dbTable.
public static GetTableByName ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName, string tableName ) : DbTable
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified database name.
tableName string The specified datatable name.`
return DbTable