Subsonic 执行存储过程,执行sql语句

//存储过程

SubSonic.Schema.StoredProcedure sp = new SubSonic.Schema.StoredProcedure("fenye");
sp.Command.AddParameter("@Id""1");
sp.Command.AddOutputParameter("@Id");
sp.Command.AddReturnParameter();
sp.Execute();
var ov = sp.Command.OutputValues;

 

//sql语句

var sql = new CodingHorror("SELECT * FROM Users WHERE Id > @p1", 0);
sql.ExecuteTypedList<DAL.User>();

 

posted @ 2011-11-06 12:59  黑色  Views(434)  Comments(0Edit  收藏  举报