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

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

Related Questions

What is an MVC and why is it important?
MVC (Model-View-Controller) is a software architectural pattern that separates an application into three interconnected components: 1. *Model*: Represents the data and business logic, managing data...
Kirti
0 0
5
where can i get best .net advanced coaching in bangalore?
You can Try Toppers Talent Track.Take a Demo class
Biswas
How can I learn ASP.NET in a month?
filter the basic concepts which will useful for the interview point and we have to learn first...if you learn priority bases it will useful for you and every time you learn what is the logic we fallow and where i can use it .
Madhavan
0 0
5
What is xamarin, how it useful in C# coders?
It is nothing but MONO for Andriod With the support Xamarin we can develop mobile application
Suresh
I'm looking Consultant or MVC Trainer
Hi, I provide .Net MVC training on the latest cutting edge technologies as MVC 5.0, Web API 2.0 and others. Please contact for more information regarding the courses.
Mary

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

Ask a Question

Related Lessons

Format Date to “MM/dd/yyyy” in Webgrid ASP.Net MVC Razor View
Replace above line with below to apply ("DD/mm/yyyy") formatting to date field in WebGrid AllTicket.Column(columnName: "DueDate", header: "Due Date") grid.Column("Date",format:@<text> @item.Date.ToString("MM/dd/yyyy")</text>)
M

Mohammad Shafi

0 0
0

Understanding Delegate in C# .NET
C# Delegate technique Delegate is one of the fantastic tool & technique in C#.NET. Using deleagte technique the following benefits could be avaialed One can define a method without name (Anonymous...

Software Development Training In Jaipur
Satyam Web Solution provides website designing &development and software designing &development training in Jaipur for various stream’s students. MCA 6 month Industrial Training/Internship B....

CLR [ Common Language Runtime ] and it's properties
CLR is one of the components of the .NET framework which provides an environment to execute the .NET code or the managed code. , CLR helps in converting the MSIL/CIL code into native code and running...
R

Raga Deepthi G.

0 0
0

C# - COLLECTIONS
Collection classes are specialized classes for data storage and retrieval. These classes provide support for stacks, queues, lists, and hash tables. Most collection classes implement the same interfaces.Collection...

Recommended Articles

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 >

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 >

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 >

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 >

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