Yesterday i was attempting to use a stored procedure with the Entity Framework through the “function import” features and couldn’t get the auto-gen feature to expose the function on the Context. The stored procedure was returning a scalar value which at this point doesn’t seem to be supported through auto-gen. Choosing an Entity, however works fine. Further digging this morning led me to this article on the ADO.NET team blog explaining the issues with return types and stored procedures in Entity Framework. The article also links to another great article showing how to return custom types two ways: one way through the entity framework itself, the other through the use of extension methods.
ADO.NET Entity Framework Extensions
Programming
.NET, C#, Entity Framework
T4 code generation has been on my short list of things to look into but keeps getting put off as i navigate down some other endless path. Meanwhile, I found a nice article on using T4 to generate stored procs for CRUD operations for the Entity Framework.
Entity Framework Stored Procedure Generation
Thanks David.
Programming, Tips and Tricks
.NET, Code Generation, T4
Ran into an issue on a website where the Session was timing out yet the forms auth ticket was still valid which was causing errors. Here is one solution:
http://dotnethitman.spaces.live.com/blog/cns!E149A8B1E1C25B14!210.entry
The GU also mentions some of this in the post and in digging through all the comments.
http://weblogs.asp.net/scottgu/archive/2005/11/08/430011.aspx
Programming, Tips and Tricks
.NET, C#
Recently i’ve been researching the default providers in .NET for Membership, Roles and Profiles and came across this code which provides a custom implementation of the above with simple db structures behind them. http://altairiswebsecurity.codeplex.com/
Tips and Tricks
.NET, .NET Custom Providers, ASP.NET