Sporadic musings from Philip Hendry

Return values from stored procedures using the Enterprise Library Data Access block

Sep 7, 2009 • Code, Enterprise Library • Less than a minute read

I’m not sure why I had so much trouble trying to do this… but because it did I think it’s worth a blog. Basically I was trying to return an int value from a stored procedure but couldn’t quite work out the syntax and was initially distracted by trying to use AddOutParameter() . However, the key was to use AddParameter() specifying the direction as ReturnValue : Read →

Selecting a result set from a stored procedure in SQL Server

Sep 2, 2009 • SQL Server, T-SQL, Tip • Less than a minute read

Selecting data from a stored procedure in SQL Server is already a documented feature and here’s an example: Read →

Lazy Loading Entities Referenced By The Returned Entities from a Stored Procedure in Entity Framework V1

Aug 28, 2009 • Code, Entity Framework • Less than a minute read

Phew, that’s the title out of the way!! Read →

‹ Newer

Older ›