EntityDAC - SQLServer and Sequence

[claudio.piffer]

Hi,

I tested the last version of the EntityDAC with a new project. This project use the new SQLServer 2014 and for the type of the primary key fields I use the new Sequence feature (introduced in SQLServer 2012) instead of Identity.

EntityDAC is compatible with the Sequence feature of SQLServer? I ask this because I have little problems that I resolved changing some line of code in the EntityDAC library.

Meanwhile, I write and send to you a sample project with the changes I made to illustrate the problems

Best Regards

Claudio

[claudio.piffer]

Hi,

I just sent in email a sample project and a PDF with the explanation of the problems.

Thank you very much

[AlexP]

Hello,

Test 1, 2, 3 return the same error: "Invalid Object Name SequenceOrders", Assert is not reproduced. Test 4 returns the correct error message, saying that the Null value can't be inserted.

[claudio.piffer]

Hi Alex,

>>Test 1, 2, 3 return the same error: "Invalid Object Name SequenceOrders", Assert is not >>reproduced. Test 4 returns the correct

I will create a new sample test without Sequence and I resend to you.

>>Test 4 returns the correct error message, saying that the Null value can't be inserted.

Yes, in debug mode I see the exception. But this exception is not re-raised then I can not seem to handle it in my code.

Thank you very much

[AlexP]

4) Yes, indeed, exception is restrained. We will fix this behavior in the next version.

[XStranger]

Meanwhile, I write and send to you a sample project with the changes I made to illustrate the problems

Please write in forum your project.
I want see your code too

[claudio.piffer]

Hi XStranger,

you are right but I cannot upload file in forum.

I am preparing a new test project. Just made I paste a url for download from my Google Drive

Best Regards

[AlexP]

Unfortunately, we haven't received your new demo project. Please send it again to alexp*devart*com .

[XStranger]

claudio.piffer, your problem is closed?

[AlexP]

The version including this fix is not yet released.

[claudio.piffer]

Hi,

sorry for delay I was very busy. No, I solved by manually editing the source (the current version not the incoming version). I look forward to the new version and I will check if everything is ok

Thank you very much AlexP for the incoming new release

Best Regards

Claudio

[AlexP]

The new EntityDAC version will be released in the nearest future (within 2 weeks).

[claudio.piffer]

Hi AlexP

any news on the new EntityDAC version? The new version will support Delphi XE8?

Thank you very much and best regards

[AlexP]

We plan to release EntityDAC with support for XE8 this week.