EntityDAC - SQLServer and Sequence

EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Sat 28 Feb 2015 13:21

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
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Sun 01 Mar 2015 15:36

Hi,

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

Thank you very much
claudio.piffer
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Mon 02 Mar 2015 11:16

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Mon 02 Mar 2015 13:36

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
claudio.piffer
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Tue 03 Mar 2015 09:45

4) Yes, indeed, exception is restrained. We will fix this behavior in the next version.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: EntityDAC - SQLServer and Sequence

Postby XStranger » Wed 04 Mar 2015 14:07

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
XStranger
 
Posts: 8
Joined: Wed 04 Mar 2015 13:55

Re: EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Wed 04 Mar 2015 17:58

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
claudio.piffer
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Tue 10 Mar 2015 11:52

Unfortunately, we haven't received your new demo project. Please send it again to alexp*devart*com .
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: EntityDAC - SQLServer and Sequence

Postby XStranger » Mon 30 Mar 2015 11:45

claudio.piffer, your problem is closed?
XStranger
 
Posts: 8
Joined: Wed 04 Mar 2015 13:55

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Tue 31 Mar 2015 09:34

The version including this fix is not yet released.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Tue 31 Mar 2015 19:22

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
claudio.piffer
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Wed 01 Apr 2015 08:05

The new EntityDAC version will be released in the nearest future (within 2 weeks).
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: EntityDAC - SQLServer and Sequence

Postby claudio.piffer » Tue 28 Apr 2015 12:16

Hi AlexP

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

Thank you very much and best regards
claudio.piffer
 
Posts: 18
Joined: Mon 30 Apr 2007 07:36

Re: EntityDAC - SQLServer and Sequence

Postby AlexP » Tue 28 Apr 2015 12:50

We plan to release EntityDAC with support for XE8 this week.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to EntityDAC