Failed to retrieve the automatically incremented column value from the server. Possible reason: A trigger does not perform 'select ID from inserted' a

[MSu]

Hello,

since I changed the SQL Server to version 2016, sometimes I get an error after inserting rows:

Failed to retrieve the automatically incremented column value from the server. Possible reason: A trigger does not perform 'select ID from inserted' as last operation.

I replaced the openAccess.Runtime.dll with a hotfix version 2015.1.225.1 --> But also with this version the error still apperars.

Any Ideas?

Thanks for helping.

Regards, Marco.

[MSu]

Additional informations:

The select @@version command on SQL Server 2016 brings following response:

Microsoft SQL Server 2016 (RTM-GDR) (KB3179258) - 13.0.1711.0 (X64)   Jul 29 2016 16:16:44   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

Has DataAccess a problem with the new Format??

[Doroteya]

Hello Marco,

The error you experience is due to the lack of support for SQL Server 2016 in Data Access Q1 2016. Such support is added for the first time in Data Access Q2 2016; since today Data Access Q2 2016 is live and you can obtain the NuGet packages from here.

I hope this helps.

Regards,
Doroteya
Telerik by Progress

 

[MSu]

Thank You for answering.

I'm using the domain model method. This method is not longer supportet on Data Access Q2 2016, is this correct?

So if I have a SQL Server 2016, I need the Data Access Q2 2016 and then I change my persitend layer to the fluent model?

Is this a possible solution?

I heard that it gives an easy method to convert the domain model in an fluent model?

Thanks for helping,

Regards Marco.

[Doroteya]

Hi Marco,

Both of your assumptions are correct:
- Data Access Q2 2016 doesn't support the Visual Studio integration (it was deprecated in Data Access Q2 2016).
- If you have SQL Server 2016, you need Data Access Q2 2016 and a fluent model.

As for the workflow for converting .rlinq files to fluent models, this blog post contains it.

Regards,
Doroteya
Telerik by Progress

 

[Patrice Boissonneault]

Thanks Telerik for letting us stuck on obsolete technology !  Very disappointed customer.  Can we send you our .rlink file so that YOU convert them to fluent model?!