ASP.Net Identity Tables

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

ASP.Net Identity Tables

Post by dcraggs » Thu 31 Oct 2019 09:09

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

MaximG
Devart Team
Posts: 1441
Joined: Mon 06 Jul 2015 11:34

Re: ASP.Net Identity Tables

Post by MaximG » Mon 04 Nov 2019 12:55

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

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Tue 05 Nov 2019 11:04

Can't log in there - says my email is invalid

Dave

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Tue 05 Nov 2019 11:17

Reset password - you should have a contact email.

Dave

Kurry
Posts: 2
Joined: Fri 25 Oct 2019 22:44

Re: ASP.Net Identity Tables

Post by Kurry » Tue 05 Nov 2019 14:16

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
Last edited by Kurry on Tue 05 Nov 2019 14:17, edited 1 time in total.

Kurry
Posts: 2
Joined: Fri 25 Oct 2019 22:44

Re: ASP.Net Identity Tables

Post by Kurry » Tue 05 Nov 2019 14:17

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

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Tue 05 Nov 2019 14:27

I reset my password so I logged ion earlier and send the message.

Dave

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Thu 07 Nov 2019 11:42

I sent the model a few days ago. Did you receive it?

Regards

Dave Craggs

MaximG
Devart Team
Posts: 1441
Joined: Mon 06 Jul 2015 11:34

Re: ASP.Net Identity Tables

Post by MaximG » Mon 11 Nov 2019 14:35

Thank you for the model. We've replied you about the use of the 'Delete On Null' property via e-support.

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Tue 12 Nov 2019 09:03

Sorry, not received anything and I have checked my junk folder.

Dave

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Tue 12 Nov 2019 09:04

Also, please note, these tables where generated by Microsoft!

Dave

dcraggs
Posts: 16
Joined: Wed 31 Jan 2007 13:19

Re: ASP.Net Identity Tables

Post by dcraggs » Wed 13 Nov 2019 13:30

Still not received anything.

Dave

MaximG
Devart Team
Posts: 1441
Joined: Mon 06 Jul 2015 11:34

Re: ASP.Net Identity Tables

Post by MaximG » Thu 14 Nov 2019 12:19

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.

Post Reply