Has anyone successfully used LINQPad 4 to test BPM LINQ queries? It would be fantastic if someone has and can share.

@erikj if no one has mentioned it lately, we appreciate your presence and input here on the forum, as we do all epicor insiders, consultants and knowledgeable users! [System.Data.Entity.DbFunction(“EpicorDB”, “ConvertToInt”)] public static int ConvertToInt(string val) { return Int32.Tr…

Are you saying we can create our own conversion functions(As long as we add it as a reference)? Or are you just pointing out what the ErpEFFFunction does?

I was just pointing out what the ErpEFFunction does (which was nothing magic). These functions are baked into the Erp model (which is what the docs said to do) and I’m not sure EF will recognize functions declared outside the model. But I’ll play with it and see what happens.

I was unsuccessful in my attempt create my own functions that worked. I did find a resource, which may be useful for others if they need to know what .Net methods will work out of the box. [image] CLR Method to Canonical Function Mapping - ADO.NET Learn more about: CLR Method to Canonic…

I can see about getting a function added to the model for converting decimals to ints. But it probably wouldn’t be backported very far. What version are you on?

10.2.200.6 patching this weekend to 10.2.200.10.

I second those remarks from Chris. Thanks for your input Erik.

A smart guy in our Birmingham, UK office reminded me that decimal has an intrinsic cast to int, which is supported by EF. Strings can’t be cast to ints, which is why we have the helper functions. But this should work… var q = Db.UD13.Select(s => new { MyNumber = (int)s.Number…

By golly you’re right. I thought I tried that but apparently not. Much simpler. I can’t believe that I didn’t find that in all my googling. I’ll share this link for valid numeric casts: [image] Built-in numeric conversions - C# reference Learn about the implicit and explicit conversion…

Hi Caleb, I’m using Epicor 10.2.200 and I’m trying to mock up and instantiate an instance of the ErpContext. I have all but the Epicor.Data.Provider reference. I tried locating it inside the Assemblies folder on the machine Epicor is installed on, but no luck. Do you know where else I can find i…

LINQPad 4 for testing BPM queries?

Experts' Corner

hkeric.wci (Haso Keric) February 10, 2019, 8:49am 58

Topic		Replies	Views
[ Tools / Download ] Epicor LINQPad Starter Kit Experts' Corner download	10	5490	June 12, 2021
Linq and Linqpad Epicor ERP 10 linq	4	1789	December 8, 2021
Kinetic LinqPad Starter Kinetic ERP	18	1967	January 3, 2024
Testing Kinetic BPM with LINQPad 7? Kinetic ERP bpm , kinetic	0	444	January 2, 2024
Interfacing Visual Studio to E10 Experts' Corner	28	10682	November 5, 2021

LINQPad 4 for testing BPM queries?

Related topics