c# - Should I be using EF6 from a SQL CLR Function -
I have been hired to take some complex calculation code (C #) and research on going into the CLR function on SQL Server. I have the problem that the calculation uses the data layer which uses EF6. Obviously I have to remove a small part of the existing code for the CLR function (SAR), but I still have to fulfill all the dependencies. My question is how can I do this [which comes later :)] so should I will do this? Either way it is wrong to fill the entire EF in the database so that I am using it to calculate - it seems very bloated. Opinion, suggestions, please consider? Thanks Unless pressing lot To keep the code-base in sync between the application layer and this SQLLLR function, I would say: No, it does not seem like, if that is the case, it is useful to do this. You need some data points and using a simple SqlConnection for those simple string context connection = true; is very easy to use -process connection). And, seeing that the performance is a conc...