LINQPad 4 for testing BPM queries?

Experts' Corner
45

@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.TryParse(val, out Int32 result) ? result : default;
   }

Here is how to format c# code on the forum
image

2 Likes
46

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?

1 Like
47

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.

1 Like
48

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.

However, there doesn’t seem to be any methods that convert decimals to integers. Since the UD tables don’t have integer fields, projecting the Decimal fields to an Integer field in an anonymous type is pretty ugly and not intuitive.

Erp.ErpEFFunctions.ConvertToInt(SqlFunctions.StringConvert((decimal)decimalvalue))

versus something simple like

Convert.ToInt32(decimalvalue)

And just to be clear, this concerns Linq to Entities. Once the records are in memory, Linq to Objects takes over and type conversions are not an issue.

1 Like
49

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?

1 Like
50

10.2.200.6 patching this weekend to 10.2.200.10.

1 Like
51

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

2 Likes
52

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.Number01

    }).ToList();
1 Like
53

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:

1 Like
54

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 it? I keep getting that " *o Entity Framework provider found for the ADO.NET provider with invariant name ‘EpiProvider’." error message like you were getting.

Thanks,

Josh

1 Like
55

So this was for 10.2.100 maybe .200

It might be instead of EpiProviderRegistration - It may be EpiProviderRegistrator ( i may even have it incorrect in the article )

Change:
// Enable for 10.2 Only: EpiProviderRegistration.Register();
for the following:
// Enable for 10.2 Only: EpiProviderRegistrator.Register();
2 Likes
56

I think I just got it.

Looks like it accepts:
Epicor.Data.Provider.EpiProviderRegistrator.Register();

That ADO error went away once I added this in.

Thanks!

2 Likes
57

Also check the LinkedIn Article :slight_smile: I need to convert it to Markdown and paste here.

1 Like
58
3 Likes
59

Have you ever had the need to instantiate a quote service (shown below)?

Erp.Contracts.QuoteSvcContract quote = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.QuoteSvcContract>(context);

It keeps giving me the error “Unable to find assembly for contract Erp.Contracts.QuoteSvcContract”.

The context instantiates fine, why wouldn’t the service?

1 Like
60

Press F4 and you have to add the Assemblies in.

2019-02-11_1313
2019-02-11_1313.png1330×618 55.6 KB

In your case Erp.Contracts.QuoteSvcContract preferrably from within your Epicor Client Directory.

1 Like
61

I didn’t notice if you used LINQPad with the OData services? It works kind of nice :wink:

2 Likes
62

for those starting out with Linq. If you have not seen 101 LINQ Samples here’s a link (pardon the pun)

3 Likes
63

getting error message saying my the provider did not return a provider manifest instance

1 Like
64

Try using this updated one for 10.2.300+ I need to update it on repo, had to reference diff .net assemblies for EF6 I used the NuGet feature in LINQPad I wonder if it sticks if I shared the updated file:

Epicor_10_LINQPad_Starter - Copy.linq (3.2 KB)

1 Like