Azavea.Open.DAO.SQL.SqlConnectionUtilities.GenerateMappingFromSchema C# (CSharp) Method

SqlConnectionUtilities Class Documentation Datei anzeigen Open project: azavea/net-dao

GenerateMappingFromSchema() public static method

Generates a simplistic classmapping (without changing any column/field names) from a table's schema. Intended for times when you are transferring data without really using it, for example from a DB to a CSV. Will most likely only be useful for a DictionaryDAO since there is no defined .NET class to map to. All column names will be returned in caps.

public static GenerateMappingFromSchema ( AbstractSqlConnectionDescriptor connDesc, string tableName ) : ClassMapping
connDesc	AbstractSqlConnectionDescriptor	Connection descriptor for the database.
tableName	string	Name of the table to generate a mapping for.
return	ClassMapping

        public static ClassMapping GenerateMappingFromSchema(AbstractSqlConnectionDescriptor connDesc,
            string tableName)
        {
            return GenerateMappingFromSchema(connDesc, tableName, null);
        }

Same methods

SqlConnectionUtilities::GenerateMappingFromSchema ( AbstractSqlConnectionDescriptor connDesc, string tableName, IComparer columnSorter ) : ClassMapping

SqlConnectionUtilities

CreateIndex

DropIndex

GenerateMappingFromSchema

GetSchema

QueryForDataSet

QueryIntoDataSet

ReadIntsFromQuery

ReadStringsFromQuery

SetSQLOnCommand

TestConnection

TruncateTable