How can I use an identity with multiple tables in ASP.NET MVC 5?

Asked by Last Modified  

1 Answer

Learn .Net

Follow 5
Answer

Please enter your answer

Manoj Kumar Vishwakarma

MS SQL SERVER DBA Trainer

No, you cannot have multiple user tables with Identity, at least not technically. All the other core components of Identity (roles, claims, logins, etc.) are setup with foreign keys to one user table. For your scenario here, you should use inheritance. For example: public class ApplicationUser...
read more
No, you cannot have multiple user tables with Identity, at least not technically. All the other core components of Identity (roles, claims, logins, etc.) are setup with foreign keys to one user table. For your scenario here, you should use inheritance. For example: public class ApplicationUser : IdentityUser public class Instructor : ApplicationUser public class Student : ApplicationUser By default, Entity Framework will create the one table for ApplicationUser and add a Discriminator column to it. This column will have one of three possible values: "ApplicationUser", "Instructor", and "Student". When EF reads from this table, it will use this column to instantiate the right class. This is what's known as single-table inheritance (STI) or alternatively as table-per-hierarchy (TPH). The main downside to this approach is that all of the properties for all of the classes must be represented on the same table. read less
Comments
Dislike Bookmark

Related Questions

How to use .net mvc?
visual studio 2012 or after that version supports mvc application, but you should also need to understand razor view, html5, linq for working on mvc.
Jayant
What is difference between "throw" and "throw ex" in .Net?
Yes, there is a difference; 1) throw ex resets the stack trace (so your errors would appear to originate from HandleException) 2) throw doesn't - the original offender would be preserved.
SEED Infotech Ltd
I am having 3+ years of hands-on experience in .net development along with C# language. Now I need to extend my technical knowledge which helps me to work in India and also in Canada where I am going in next six months. Can any one suggest me what to learn to enhance my technical level?
Angular 7.0 and Python are good scope for another 1 to 2 years
ASHOKKUMAR
I want to learn .net
Better to search Real time Developer And Trainer then you have bring the training from him/her. wish you all the best.
Naresh
What is ASP.Net?
ASP.NET is an open source server-side Web application framework designed for Web development to produce dynamic Web pages. It was developed by Microsoft to allow programmers to build dynamic web sites, web applications and web services.
Aadarsh

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

.NET With AngularJS Training Program Syllabus
What You will Learn in .NET with AngularJS Training Program? Introduction to .Net: Features of .Net, CTS, CLS, CLR and MSIL. C# & .Net Basics and Branching & Flow Control. OOPs Concepts,...

Decode Classes

0 0
View Comments0
Facebook Analytics
Assume how the Facebook application will store the millions of customer's record in real-time: facebook = { 'jose': { 'name': 'jose', 'age': 33, 'hobby': , # cricket,football 'mobile': 1111111111, 'email':...

Logeswaran

0 0
View Comments0
Export To Excel using StringBuilder in ASP.net MVC C#
public ActionResult Export() { StringBuilder sb = new StringBuilder(); //static file name, can be changes as per requirement string sFileName = "filename.xls"; //Bind...
M

Mohammad Shafi

1 0
View Comments1
Differences Between Execution Query, Execute Scalar and Execute Reader.
ExecuteNonQuery ExecuteNonQuery method will return number of rows effected with INSERT, DELETE or UPDATE operations. This ExecuteNonQuery method will be used only for insert, update and delete, Create,...

Suprio Dutta

0 0
View Comments0
Roll up your sleeves and get knee deep into coding!
Practise, make mistakes, learn to search for solutions,seek help when stuck badly! Just attending classes won't make you good at coding!!!

Ramesh

0 0
View Comments0

Recommended Articles

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Find .Net Training near you
.Net Training in Bangalore
.Net Training in Hyderabad
.Net Training in Pune
.Net Training in Chennai
.Net Training in Mumbai
.Net Training in Delhi
.Net Training in Noida
.Net Training in Kolkata
.Net Training in Jaipur
.Net Training in Coimbatore
Online .Net Training

Looking for .Net Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you