Enterprise Library 4 之 DAAB使用

引用自：
Enterprise Library 2.0 -- Data Access Application Block　和　加密数据库连接字符串
http://www.cnblogs.com/adamoooo/articles/892618.html



取得存储过程的返回值、输出参数

---

 带输出参数的：

             try
            {
                Database db  =  DatabaseFactory.CreateDatabase();
                DbCommand cmd  =  db.GetStoredProcCommand( " usp_xxx " );

                db.AddParameter(cmd,  " @UserID " , DbType.Int32, ParameterDirection.InputOutput,  "" , DataRowVersion.Current, dict.Get( " UserID " ,  0 ));
                db.AddInParameter(cmd,  " @LoginName " , DbType.String, dict[ " LoginName " ]);
                
                db.ExecuteNonQuery(cmd);
                 return  DictionaryEx.Create( " UserID " , db.GetParameterValue(cmd,  " @UserID " ));
            }
             catch  (Exception)
            {
                 return   null ;
            }        

带返回值：

try
            {
                Database db  =  DatabaseFactory.CreateDatabase();
                DbCommand cmd  =  db.GetStoredProcCommand( " usp_xxx " );
                db.AddInParameter(cmd,  " @UserID " , DbType.Int32, dict[ " UserID " ]);
                
                db.AddParameter(cmd,  " @ret " , DbType.Int32, ParameterDirection.ReturnValue,  "" , DataRowVersion.Default,  null );
                db.ExecuteNonQuery(cmd);

                 return  cmd.Parameters[ " @ret " ].Value;
            }
             catch  (Exception)
            {
                 return   null ;
            }

查询返回结果集：

try
            {
                Database db  =  DatabaseFactory.CreateDatabase();
                DbCommand cmd  =  db.GetStoredProcCommand( " usp_xxx " );
                db.AddInParameter(cmd,  " @rowStart " , DbType.Int32, dict.Get( " rowStart " ,  null ));
                db.AddInParameter(cmd,  " @rowEnd " , DbType.Int32, dict.Get( " rowEnd " ,  null ));

                 return  db.ExecuteDataSet(cmd);
            }
             catch  (Exception)
            {
                 return   null ;
            }

 

转载于:https://www.cnblogs.com/kiant71/archive/2010/04/05/1752010.html