本文整理汇总了C#中DataConnection.ExecuteReader方法的典型用法代码示例。如果您正苦于以下问题：C# DataConnection.ExecuteReader方法的具体用法？C# DataConnection.ExecuteReader怎么用？C# DataConnection.ExecuteReader使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataConnection的用法示例。
在下文中一共展示了DataConnection.ExecuteReader方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetSchema
public override DatabaseSchema GetSchema(DataConnection dataConnection, GetSchemaOptions options = null)
{
DefaultSchema = dataConnection.Execute<string>("SELECT CURRENT_SCHEMA FROM DUMMY");
_databaseName = ((DbConnection)dataConnection.Connection).Database;
_dataSourceName = ((DbConnection) dataConnection.Connection).DataSource;
if (String.IsNullOrEmpty(_dataSourceName) || String.IsNullOrEmpty(_databaseName))
{
using (var reader = dataConnection.ExecuteReader(@"
SELECT
HOST,
KEY,
VALUE
FROM M_HOST_INFORMATION
WHERE KEY = 'sid'"))
{
if (reader.Reader.Read())
{
_dataSourceName = reader.Reader.GetString(0);
_databaseName = reader.Reader.GetString(2);
}
}
}
return base.GetSchema(dataConnection, options);
}示例2: GetProcedureSchema
protected virtual DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
{
using (var rd = dataConnection.ExecuteReader(commandText, commandType, CommandBehavior.SchemaOnly, parameters))
{
return rd.Reader.GetSchemaTable();
}
}示例3: GetProcedureSchema
protected override DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
{
if (commandType == CommandType.StoredProcedure)
{
commandText = "{ CALL " + commandText + "(" + String.Join(",", parameters.Select(x => "?")) + ")}";
}
//bug SchemaOnly simply doesn't work
dataConnection.BeginTransaction();
try
{
using (var rd = dataConnection.ExecuteReader(commandText, CommandType.Text, CommandBehavior.Default, parameters))
{
return rd.Reader.GetSchemaTable();
}
}
finally
{
dataConnection.RollbackTransaction();
}
}示例4: GetProcedureSchema
protected override DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
{
//bug in drivers, SchemaOnly executes statement
dataConnection.BeginTransaction();
try
{
using (var rd = dataConnection.ExecuteReader(commandText, commandType, CommandBehavior.SchemaOnly, parameters))
{
return rd.Reader.GetSchemaTable();
}
}
finally
{
dataConnection.RollbackTransaction();
}
}