Page 1 of 1

ASP.Net Identity Tables

Posted: Thu 31 Oct 2019 09:09
by dcraggs
HI,

I am evaluating EntityDAC. I am getting errors with a database that uses Microsoft Asp.Net generated identity tables:

1 Association 'Aspnetuser_Aspnetuserclaim' is based on a non-nullable property(ies). In case any 'Aspnetuserclaim' object is removed from 'Aspnetuser'.'Aspnetuserclaims', an exception will be thrown.It is recommended to set the 'Delete On Null' association property to True for this association.

2 Association 'Aspnetuser_Aspnetuserlogin' is based on a non-nullable property(ies). In case any 'Aspnetuserlogin' object is removed from 'Aspnetuser'.'Aspnetuserlogins', an exception will be thrown.It is recommended to set the 'Delete On Null' association property to True for this association

Any ideas?

Regards

Dave Craggs

Re: ASP.Net Identity Tables

Posted: Mon 04 Nov 2019 12:55
by MaximG
Thank you for the information. Please send us the model (*.enml) used in your sample. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Re: ASP.Net Identity Tables

Posted: Tue 05 Nov 2019 11:04
by dcraggs
Can't log in there - says my email is invalid

Dave

Re: ASP.Net Identity Tables

Posted: Tue 05 Nov 2019 11:17
by dcraggs
Reset password - you should have a contact email.

Dave

Re: ASP.Net Identity Tables

Posted: Tue 05 Nov 2019 14:16
by Kurry
dcraggs wrote:
Tue 05 Nov 2019 11:04
Can't log in there - says my email is invalid

Dave
Sign up. Your forum login won't fit

Re: ASP.Net Identity Tables

Posted: Tue 05 Nov 2019 14:17
by Kurry
dcraggs wrote:
Tue 05 Nov 2019 11:04
Can't log in there - says my email is invalid

Dave
Sign up. Your forum login won't fit

Re: ASP.Net Identity Tables

Posted: Tue 05 Nov 2019 14:27
by dcraggs
I reset my password so I logged ion earlier and send the message.

Dave

Re: ASP.Net Identity Tables

Posted: Thu 07 Nov 2019 11:42
by dcraggs
I sent the model a few days ago. Did you receive it?

Regards

Dave Craggs

Re: ASP.Net Identity Tables

Posted: Mon 11 Nov 2019 14:35
by MaximG
Thank you for the model. We've replied you about the use of the 'Delete On Null' property via e-support.

Re: ASP.Net Identity Tables

Posted: Tue 12 Nov 2019 09:03
by dcraggs
Sorry, not received anything and I have checked my junk folder.

Dave

Re: ASP.Net Identity Tables

Posted: Tue 12 Nov 2019 09:04
by dcraggs
Also, please note, these tables where generated by Microsoft!

Dave

Re: ASP.Net Identity Tables

Posted: Wed 13 Nov 2019 13:30
by dcraggs
Still not received anything.

Dave

Re: ASP.Net Identity Tables

Posted: Thu 14 Nov 2019 12:19
by MaximG
For a detailed description of the purpose of "Delete On Null" property, see:
https://www.devart.com/linqconnect/docs ... 1524030967 (Section "Deleting Dependent Entities")
The visual editor EntityDeveloper is a common tool for working with models in a range of our products. The "Delete On Null" property in EntityDAC is ignored. You can set it to True, which a recommended value. In the next version of EntityDeveloper, that Warning won't be generated when working in EntityDAC.