Strange error -

Toshal Infotech

07
Jul 2013

Strange error - "Unable to Find EntitySpaces.Npgsql2Provider.dll"

Posted by on July 07, 2013 12:03

I was working to get EntitySpaces to work with PostgreSql. While I had all dlls in correct places but still keep getting exception - "Unable to Find EntitySpaces.Npgsql2Provider.dll".

First I thought it require dlls in GAC - didn't helped.
May be Npgsql.dll version - downloaded exact version from Postgres site - didn't helped.
Looked at EntitySpaces documentations - didn't helped.
Googled for help - didn't helped.
Looked at EntitySpaces forums - didn't helped.
Looked at EntitySpaces Blogs - didn't helped.

To my surprise there is not even much of documentation from EntitySpaces team for PostgreSql provider. Not even how provider should be configured. Just one liner in Assembly list documentation.

Anyway, since we are using EntitySpaces from their v1, I remember one change they made few years ago - LoaderMT. This is provider loader for Medium Trust environment. Before that EntitySpaces always needed Full trust since they were doing reflections to load providers.

Only note from EntitySpaces triggered this memory was in EntitySpaces studio. When you select PostgreSQL for connection there is note added bellow connection string textbox - "The EntitySpaces Metadata Engine uses reflection to load Npgsql, you can either install a copy in the GAC or in the 'C:\Program Files (x86)\EntitySpaces 2012\CodeGeneration\Bin' folder. You must have a version in the GAC to use the Visual Studio Plugin, otherwise you will have to run the StandAlone application located on your Start -> Programs menu. You can save your settings as the default by clicking the 'Save Default Settings' icon on the toolbar."

"Reflection"! This means that if you are using LoaderMT provider (like me) in your application you will not be able to use EntitySpaces.Npgsql2Provider.dll and keep getting "Unable to Find EntitySpaces.Npgsql2Provider.dll".

Solution - very easy just use EntitySpaces.Loader.dll instead of EntitySpaces.LoaderMT.dll. Only catch - you are no longer capable of running your app in Medium trust environment.

Hope this help.

0 Years in
Operation

0 Loyal
Clients

0 Successful
Projects

Words from our clients

Toshal is an incredible team to work with. I'm always able to trust their technical proficiency in any project I give them, but where they stand apart is how collaborative and hardworking they are. Anytime we work together, I'm always 100% confident the work will be completed on time and as expected. I love working with Toshal!
Eric Seidel (Atlanta, GA, USA)
We are pleased to recommend our longtime partner, Toshal Infotech Pvt. Ltd. For over a decade, we relied on Ashish’s team at Toshal to provide us with timely development services and expert advice in a range of web technologies and assist us with occasional graphics and design assignments. We look forward to working with this group for many more years.
Bo Simmons (Atlanta, GA, USA)
Toshal Infotech Pvt. Ltd. has been a trusted web development partner for our company for nearly a decade. They are responsive, effective, and so wonderful to work with. We are lucky to have found such a great partnership.
Kristen Everett (Atlanta, GA, USA)
Always a pleasure to work with Toshal Infotech Pvt. Ltd. Great work, fast delivery, pleasant and polite seller. Definitely recommended.
Very helpful seller. Works well and delivers good work. Very happy with everything. Would recommend and will use again.
As always, a pleasure working with you - I can't believe how quick you did this update for me.thank you so much. looking forward to working with you on many more projects to come :)
FANTASTIC service - I'm amazed at how fast they managed to turn this modification to my app around. the level of service and communication was flawless, absolutely brilliant. they are not only good and incredibly skilled at what they do, they are also friendly and have GREAT communication skills. I will definitely be using you again :) thank you
seller is very good and delivered in time..worth buying..
Very happy to work again with them. They are always proactive in solving everything and the communication is great too.
We needed an android app on a deadline. They exceeded our expectations in every way, communication was great, and they worked in a very responsible way. Will definitely work with them again.

Tell Us About Your Project

contact me

We’ve done lot’s of work, Let’s Check some from here

View All Projects

Do You Have Any Project?

We are ready to take your project to the next level. Don’t hesitate to contact us. Our awesome and creative team will bring you the best solution.

Send Project Details

Our company has been developing high-quality and reliable software for corporate needs since 2008. We are renowned professionals of software development.

Strange error - "Unable to Find EntitySpaces.Npgsql2Provider.dll"

By Author

By Year

Words from our clients

Tell Us About Your Project

We’ve done lot’s of work, Let’s Check some from here

Do You Have Any Project?

We are ready to take your project to the next level. Don’t hesitate to contact us. Our awesome and creative team will bring you the best solution.

Menu

What We Offer

Our contacts

Surat

Pune