Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hi friends
Can you guys tell me how we can use Stored procedures in Umbraco. I have doubts how we can implement it with SQLHelper and add parameters.
Best Regards
Sujith pv
SQLHelper just runs dynamic SQL so you can run a stored procedure by passing a string to execute it - something like "exec sproc @param=value".
Not ideal, but it's easy enough to reference your own DAL instead.
I wouldn't use the Umbraco data layer for any of your own custom stuff, you should always use your own ORM and DAL.
NHibernate, Subsonic, Entity Framework 4, etc are all good choices.
And don't forget LLBLGen is also a good choice for an ORM and DAL ;).
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
How can we use stored procedures with Umbraco
Hi friends
Can you guys tell me how we can use Stored procedures in Umbraco. I have doubts how we can implement it with SQLHelper and add parameters.
Best Regards
Sujith pv
SQLHelper just runs dynamic SQL so you can run a stored procedure by passing a string to execute it - something like "exec sproc @param=value".
Not ideal, but it's easy enough to reference your own DAL instead.
I wouldn't use the Umbraco data layer for any of your own custom stuff, you should always use your own ORM and DAL.
NHibernate, Subsonic, Entity Framework 4, etc are all good choices.
And don't forget LLBLGen is also a good choice for an ORM and DAL ;).
is working on a reply...