The default database profile for NexusDB indicates SupportsAutoIncs=“False”. However, this causes problems with NexusDB versions at least since v4.00 (which is several years old) when working with the .NET version of DA. I had problems with this a while ago, and after tracking the issue, I realized this was the problem. I created a custom DataAsbstract.daConfig file in my project, and the problem was solved.
This is the profile I’m using:
<DatabaseProfiles> <NexusDB QuotingIdentifiers='""'> ... <GetLastAutoInc SQL="SELECT LASTAUTOINC as LastAutoInc FROM #DUMMY" SupportsAutoIncs="True"/> ... </NexusDB> </DatabaseProfiles>
I think this is still the case in the latest version of DA, so I thought I’d report it.