Databases
StackOverflow2013
Postsdbo
POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
    primarykey
    data
    text
    <p>I'm drawing from different questions (listed below as I ask the question).</p> <p>I would like to do five things and as far as I can tell from these questions and answers... all of this can be done in my OnModelCreating method.</p> <p><strong>Preface</strong>: I am using the latest nightly bits for Asp.Net Identity 1.1-alpha</p> <ul> <li><p>I would like to use "UserId" instead of Id as the property for my Users Id in the AspNetUsers table. I understand this would involve using "HasColumnName" during OnModelCreating.</p></li> <li><p>I would like to use Guid (uniqueidentifier) as the data type for my UserId (instead of string). I understand that this involves using my own POCOS for IUser class and IUserStore, etc as Hao Kung Indicates in his answer here...</p></li> </ul> <p><a href="https://stackoverflow.com/questions/19553424/how-to-change-type-of-id-in-microsoft-aspnet-identity-entityframework-identityus/19577113#19577113">How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser</a></p> <ul> <li>I would like to use my own custom table names such as MyRoles, MyCUserClaims, MyUserLogins, MyUserRoles, MyUsers as indicated in this answer...</li> </ul> <p><a href="https://stackoverflow.com/questions/19460386/how-can-i-change-the-table-names-when-using-visual-studio-2013-aspnet-identity">How can I change the table names when using Visual Studio 2013 ASP.NET Identity?</a></p> <ul> <li>All the foreign keys should be mapped apppropriately with the Asp.net Identity tables as Hao Kung shows here...</li> </ul> <p><a href="https://stackoverflow.com/questions/19932993/create-asp-net-identity-tables-using-sql-script/20057794#20057794">Create ASP.NET Identity tables using SQL script</a></p> <ul> <li>I would like to add properties to the ApplicationUser of FirstName and LastName.</li> </ul> <p>So, based on the above... can someone provide me with the OnModelCreating method which would create these Identity tables accordingly, with UserId as the Id column for the users of type Guid (uniqueidentifier), in tables with custom names, with the appropriate foreign key relationships, and with two additional properties on ApplicationUser of FirstName and LastName?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser2315985
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
      1. USuser2315985
      1. VTBountyStart
    2. VO
      singulars
      1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo you've found all of the related posts on how to do what you want, you just don't want to do it yourself? Have you tried any of it? Did you have issues?
      singulars
      1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
      1. USJack
    2. CO@Jack Good point. I can do these separately. The problem is I can make it use Guid for an Id (instead of ints) but not when I change the table names. I assume when 1.1 is complete all will be easier.
      singulars
      1. POCreating a Custom Implementation using Guid and Custom Table names with Asp.net Identity 1.1 Alpha
      1. USuser2315985
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload