Use Entity Framework in CLR Stored procedure

Question

I found a post from seven or so years ago that the Entity Framework could not be used in a CLR stored procedure. Has this been rectified in the past seven or so years? Is an update available that will allow the Entity Framework to work in a CLR stored procedure?

I do believe that is still the case. Not to be funny or anything - but why would you ever want to do that? — Niels Berglund
– Niels Berglund, Commented Jan 16, 2018 at 16:16
The rest of the system uses the Entity Framework. I occasionally find CLR stored procedures to be convenient. But, for system maintainability, I would want to utilize the same data layer in any .NET code I write that is used throughout the rest of the system. Why would I not want to use the Entity Framework in a CLR stored procedure? — SlipEternal
– SlipEternal, Commented Jan 16, 2018 at 16:29
I guess I am asking, is there a vulnerability I would be opening up if the Entity Framework were allowed to be accessed by a CLR stored procedure? — SlipEternal
– SlipEternal, Commented Jan 16, 2018 at 16:43

David Browne - Microsoft · Accepted Answer · 2018-01-17 14:57:37Z

1

The normal reason you don't do this is that if you did, you would have to install all of .NET Framework assemblies that EF depends on into the database as unsafe assemblies, and you would have to update them every time the .NET Framework on the server was updated. As of EF 6.2 that list is :

smdiagnostics.dll
system.runtime.serialization.dll
system.dynamic.dll
microsoft.csharp.dll

This is in addition to installing updated versions of

entityframework.dll  
entityframework.sqlserver.dll

Which would come along with updated versions of your custom CLR dll.

And then you would have to start testing EF in SQL CLR to determine if it a) works and b) plays nicely in SQLCLR's unique hosting environment.

edited Jan 17, 2018 at 14:57

answered Jan 16, 2018 at 22:14

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

SlipEternal Over a year ago

That makes sense and sounds like more effort than I am willing to make. Thank you!

Abhijeet Over a year ago

@David, thanks for sharing your inputs.. Can I ask you a related question?

David Browne - Microsoft Over a year ago

Sure. Although you might just want to ask a new StackOverflow question and link it here.

Abhijeet Over a year ago

@DavidBrowne-Microsoft, thanks here it is: stackoverflow.com/questions/56823569/…

Collectives™ on Stack Overflow

Use Entity Framework in CLR Stored procedure

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related