How do I use Entity Framework in a CLR stored procedure?

No, you can't. Visual Studio wouldn't even let you add the file or project type. (That's too bad, I wanted to do that also to process some really complex logic.).

You cannot - at least not at this time. The CLR contained in SQL Server 2005 through 2008 R2 is the . NET 2.0 CLR - and Entity Framework 4 requires the .

NET 4 framework. So for now, when doing stuff inside a SQL-CLR method, you're limited to straight ADO. NET 2.0 only.

The bigger question then remains: why on earth would you want to use EF4 inside a SQL-CLR function? Those are intended to be stored proc, user-defined functions, user-defined aggregates - but certainly not full-blown database apps, really...

Some of us are not that keen to maintain database schema metadata in two or more places. EF is great to do this, but if one wants to employ the performance benefits of SQL-CLR the schema has to be defined in its context. Which at the moment means a custom metadata codes in SQL-CLR assembly that generates DDL to define a database and import it to EF.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.