It's important to understand LINQ order in order to write correct LINQ statements.
Recently I bumped into this one:
public CRM_OPPORTUNITYCLOSED GetAcceptanceClosed(Guid guid)
return Context.CRM_OPPORTUNITYCLOSEDSet.FirstOrDefault(o => o.OPPORTUNITY_ID == guid.ToString());
When this was run to the Oracle DB, I got this error:
ORA-00932: inconsistente gegevenstypen: - verwacht, NCLOB gekregen
or in English:
ORA-00932: inconsistent datatypes: expected - got CLOB
So what happened? You would expect that the ToString() was called before EF would go the the DB? In this case NO. It passes the Guid value to the DB and you get the error above.
So do your to string convert before you use the query.
public CRM_OPPORTUNITYCLOSED GetAcceptanceClosed(string guid)
return Context.CRM_OPPORTUNITYCLOSEDSet.FirstOrDefault(o => o.OPPORTUNITY_ID == guid);
We are starting up several Anguar JS (in typescript) projects with an .Net WebAPI2 background. This is really an pleasure to work with, it's like playing with lego when you're 10 years old. Keep building and inventing new things.
One of the things that all applications require is security. Inside our application we can use windows authentication. To set this up was really easy, that is, to set it up for simple GET requests. But with POSTS it gets more tricky. Ruben Biesemans from SPIKES explains this in details here:
Hope this will help solving this nasty preflight errors.