使用字典从sql server读取数据 [英] read data from sql server with dictionary

问题描述

 var query =" SELECT OrderNo，PlannedQuantity，CompletedQuantity，IsClosed" 
                +" FROM Order1 WHERE OrderNo =：orderNo" ;; 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; var arguments = new Dictionary< string，object>（）{{" orderNo"，orderNo}}; 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; using（var reader = ExecuteDatabaseReader（query，arguments））
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; if（reader.Read（））
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; return GetOrderFromReader（reader）; 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; } 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; } 
 静态IDataReader ExecuteDatabaseReader（字符串查询，IDictionary<字符串，对象>参数）
  &NBSP; &NBSP; &NBSP; {
我需要的是这个功能
 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 
  &NBSP; &NBSP; &NBSP; &NBSP;&NBSP; 
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; return null; 
  &NBSP; &NBSP; &NBSP; } 

解决方案

< blockquote>

您好，

有几个问题。

这是针对SQL-Server的吗？我问，因为你的查询使用Oracle语法作为参数而不是@OrderNo。

如果您打算将此用于Oracle和SQL-Server，那么我们需要知道这一点。

继续使用上面是使用IDataReader的原因，因为有多个数据库引擎被定位？

var query = "SELECT OrderNo, PlannedQuantity, CompletedQuantity, IsClosed"
                + " FROM Order1 WHERE OrderNo =:orderNo";
            var arguments = new Dictionary<string, object>() { { "orderNo", orderNo } };
            using (var reader = ExecuteDatabaseReader(query, arguments))
            {
                if (reader.Read())
                {
                    return GetOrderFromReader(reader);
                }
            }
 static IDataReader ExecuteDatabaseReader(string query, IDictionary<string, object> arguments)
        {
What I need is the for this function

           
          
            return null;
        }

解决方案

Hello,

A couple of questions.

Is this for SQL-Server? I ask because your query uses Oracle syntax for parameter rather than @OrderNo.

If your intent is to use this for both Oracle and SQL-Server then we need to know this.

Going with the above, is the reason for using IDataReader because more than one database engine is being targeted?

这篇关于使用字典从sql server读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！