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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.