在做项目的过程中遇到一个问题,DataReader竟然无法关闭.........
DbCommand command=..................;
DbDataReader reader = null;
DataTable dtFields = null;
try
{
reader = command.ExecuteReader(CommandBehavior.KeyInfo);
dtFields = reader.GetSchemaTable();
}
finally
{
reader.Close() //reader无法关闭
}
将 reader = command.ExecuteReader(CommandBehavior.KeyInfo)
改为 reader = command.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SingleResult);
问题消失
DbCommand command=..................;
DbDataReader reader = null;
DataTable dtFields = null;
try
{
reader = command.ExecuteReader(CommandBehavior.KeyInfo);
dtFields = reader.GetSchemaTable();
}
finally
{
reader.Close() //reader无法关闭
}
将 reader = command.ExecuteReader(CommandBehavior.KeyInfo)
改为 reader = command.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SingleResult);
问题消失