本文整理匯總了C#中Npgsql.NpgsqlDataAdapter.FillSchema方法的典型用法代碼示例。如果您正苦於以下問題：C# NpgsqlDataAdapter.FillSchema方法的具體用法？C# NpgsqlDataAdapter.FillSchema怎麽用？C# NpgsqlDataAdapter.FillSchema使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Npgsql.NpgsqlDataAdapter的用法示例。
在下文中一共展示了NpgsqlDataAdapter.FillSchema方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: Select
/// <summary>
/// Executes a SELECT statement against the database and returns a disconnected data table. NOTE: Use this overload to work with Typed DataSets.
/// </summary>
/// <param name="selectQuery">The query to be executed against the database</param>
/// <param name="dataTable">Table that will contain the result</param>
/// <returns>A data table object</returns>
public override DataTable Select(Query selectQuery, DataTable dataTable)
{
#region Input Validation
if (selectQuery == null)
{
throw new ArgumentNullException("selectQuery");
}
if (dataTable == null)
{
throw new ArgumentNullException("dataTable");
}
#endregion Input Validation
if (selectQuery.SqlStatement.Contains("TOP 2"))
{
selectQuery = CreateQuery(selectQuery.SqlStatement.Replace("TOP 2 ", string.Empty).Replace(";",string.Empty) + " LIMIT 2");
}
if (selectQuery.SqlStatement.Contains("["))
{
selectQuery = CreateQuery(selectQuery.SqlStatement.Replace("[", string.Empty).Replace("]", string.Empty));
}
IDbConnection connection = GetConnection(connectionString);
NpgsqlDataAdapter adapter = new NpgsqlDataAdapter();
adapter.SelectCommand = (NpgsqlCommand)GetCommand(selectQuery.SqlStatement, connection, selectQuery.Parameters);
try
{
//Logger.Log(selectQuery);
adapter.Fill(dataTable);
adapter.FillSchema(dataTable, SchemaType.Source);
return dataTable;
}
catch (Exception ex)
{
throw new System.ApplicationException("Error executing select query against the database.", ex);
}
}