How do I use Entity Framework in a CLR stored procedure?
- by Ivan
I am looking forward to move all the logic (which is implemented as manipulating Entity Framework 4 objects) to a server side. It looks going to be simple (thanks to the application structure) and beneficial (as all I have is one oldy laptop as a client and one tough server which runs SQL Server 2008, and building a separate service for the logic can just introduce more latency if compared to doing it inside the database).
So how do I correctly use Entities Framework inside a CLR stored procedure and make it using a host-server-provided SqlContext?