Subsonic直接执行SQL语句

int ccost = 1;
string strSql2 = string.Format("select ID, LineID, adultPrice from zg_linePrice where ID >= @ID order by id desc");
QueryCommand cmd2 = new QueryCommand(strSql2, _ManageDB.Provider);
cmd2.AddParameter("@ID", 6000, DbType.Int32);
DataSet ds = _ManageDB.Provider.ExecuteDataSet(cmd2);

posted @ 2012-07-26 09:34  木枫  阅读(207)  评论(0)    收藏  举报