What configuration is required to use Linqpad with Epicor 10?
I am getting the error:
Schema specified is not valid. Errors: (0,0) : error 0175: The specified store provider cannot be found in the configuration, or is not valid.
So far, I've debugged it to look for a provider string called "EpiProvider", but I can't figure out what's missing. I can load the Entities list on the left (using the ObjectContext connection).
source to share
When I first tried it, it didn't work. I thought it had something to do with the views that were in the [dbo] schema Epicor created when you have an extended UD table attached to a regular table.
I decided to give it a try because now I know a little about it and found it works well enough, but the table structure is so huge that it can be a little misleading. For example, I went straight to test this by trying to pull out a record of one part
from p in Part
where p.Company == "foo" && p.PartNum == "1234567890"
select p
This throws the error "InvalidOperationException: Members" System.Data.Linq.Binary UD_SysRevID and "System.Data.Linq.Binary SysRevID" marked as version string. "because LingPad apparently doesn't like the table to have multiple Row Version columns, which is what happens when Epicor merges the columns in Part and Part_ud into the same view.
To make things more interesting as the view [dbo] is created. [Part], LinqPad calls up the actual Part table in [Erp]. The [Part] Erp_Part that forever notified me because all the tables I use are pretty much in C or P and everything in between is scrolling. It didn't even change my mind as I had to expand the schema to get to the listing.
The good news is that this works great.
from e in Erp_Part
where e.Company == "foo" && e.PartNum == "1234567890"
from u in Part_UD
where u.ForeignSysRowID == e.SysRowID
select new { e, u }
Good hunting!
source to share