C# 클래스 DbDictExport.Core.Dal.DataAccess

DataAccess class for get the database data.

파일 보기 프로젝트 열기: NeilQ/DbDictExport

공개 메소드들

메소드	설명
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.

메소드 상세

GetDbColumnList() 공개 정적인 메소드

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.
리턴	List

GetDbColumnList() 공개 정적인 메소드

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.
리턴	List

GetDbNameList() 공개 정적인 메소드

Gets a list of database name.

public static GetDbNameList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder ) : List
connBuilder	System.Data.SqlClient.SqlConnectionStringBuilder	The specified SqlConnectionStringBuilder.
리턴	List

GetDbTableListWithColumns() 공개 정적인 메소드

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.
리턴	List

GetDbTableNameListWithoutColumns() 공개 정적인 메소드

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.
리턴	List

GetResultSetByDbTable() 공개 정적인 메소드

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.
리턴	System.Data.DataTable

GetTableByName() 공개 정적인 메소드

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.`
리턴	DbTable