Page 1 of 1
EntityDAC - SQLServer and Sequence
Posted: Sat 28 Feb 2015 13:21
by 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
Re: EntityDAC - SQLServer and Sequence
Posted: Sun 01 Mar 2015 15:36
by claudio.piffer
Hi,
I just sent in email a sample project and a PDF with the explanation of the problems.
Thank you very much
Re: EntityDAC - SQLServer and Sequence
Posted: Mon 02 Mar 2015 11:16
by 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.
Re: EntityDAC - SQLServer and Sequence
Posted: Mon 02 Mar 2015 13:36
by 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
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 03 Mar 2015 09:45
by AlexP
4) Yes, indeed, exception is restrained. We will fix this behavior in the next version.
Re: EntityDAC - SQLServer and Sequence
Posted: Wed 04 Mar 2015 14:07
by XStranger
claudio.piffer wrote:
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
Re: EntityDAC - SQLServer and Sequence
Posted: Wed 04 Mar 2015 17:58
by 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
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 10 Mar 2015 11:52
by AlexP
Unfortunately, we haven't received your new demo project. Please send it again to alexp*devart*com .
Re: EntityDAC - SQLServer and Sequence
Posted: Mon 30 Mar 2015 11:45
by XStranger
claudio.piffer, your problem is closed?
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 31 Mar 2015 09:34
by AlexP
The version including this fix is not yet released.
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 31 Mar 2015 19:22
by 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
Re: EntityDAC - SQLServer and Sequence
Posted: Wed 01 Apr 2015 08:05
by AlexP
The new EntityDAC version will be released in the nearest future (within 2 weeks).
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 28 Apr 2015 12:16
by 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
Re: EntityDAC - SQLServer and Sequence
Posted: Tue 28 Apr 2015 12:50
by AlexP
We plan to release EntityDAC with support for XE8 this week.