1 Answer, 1 is accepted
0
Accepted
Hi Majid,
as OpenAccess does not generate a SP-specific proxy you will need to use IObjectScope.GetSqlQuery(string,Type,string) to call a stored procedure.
Example:
IQuery q = scope.GetSqlQuery("foobar ?, ?",null,"INTEGER i, FLOAT f");
IQueryResult r = q.Execute(new object[] { 42, 0.1234f });
r.GetEnumerator(); // triggers the execution!
This would execute the foobar SP with the integer parameter 42 and the float parameter 0.1234.
The result would be discarded.
Please see the reference guide on the GetSqlQuery method too.
Best wishes,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
as OpenAccess does not generate a SP-specific proxy you will need to use IObjectScope.GetSqlQuery(string,Type,string) to call a stored procedure.
Example:
IQuery q = scope.GetSqlQuery("foobar ?, ?",null,"INTEGER i, FLOAT f");
IQueryResult r = q.Execute(new object[] { 42, 0.1234f });
r.GetEnumerator(); // triggers the execution!
This would execute the foobar SP with the integer parameter 42 and the float parameter 0.1234.
The result would be discarded.
Please see the reference guide on the GetSqlQuery method too.
Best wishes,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.