Devart Forums

I followed the following directions which installs table into MySQL database:

http://www.devart.com/dotconnect/mysql/ ... cific.html

However, there is an application that I am using that is looking for a table called IdentityRoles. This table was not installed using the above directions.

I'd like to manually install these tables but the C:\Program Files (x86)\Devart\dotConnect\MySQL\Web\ASP.NET Identity 2\install_identity_tables.sql does not contain definitions for IdentityRoles or IdentityUsers

Can you provide the schema for the MySQL tables?

Using dotconnect version 8.3.359.0

1. Which tutorial are you following?
a) Using ADO.NET Implementation of ASP.NET Identity 2 for MySQL
b) Using Entity Framework Implementation of ASP.NET Identity 2.0 for MySQL

2. Please create a new ASP.NET MVC 5 application and perform all the steps from the corresponding tutorial. Does it work?

3. Specify the exact version and update of your Visual Studio (via the Help > About menu).

Using method B

Install-Package Microsoft.AspNet.Mvc -Version 5.2.3

This tutorial installs the following tables into mysql:

`AspNetRoles`
`AspNetUserClaims`
`AspNetUserLogins`
`AspNetUserRoles`
`AspNetUsers`
`IdentityUsers`

There is no identityRoles table. I need this table.

Microsoft Visual Studio Professional 2013
Version 12.0.31101.00 Update 4
Microsoft .NET Framework
Version 4.5.51641

Installed Version: Professional

LightSwitch for Visual Studio 2013 06177-179-0039547-02399
Microsoft LightSwitch for Visual Studio 2013

Team Explorer for Visual Studio 2013 06177-179-0039547-02399
Microsoft Team Explorer for Visual Studio 2013

Visual Basic 2013 06177-179-0039547-02399
Microsoft Visual Basic 2013

Visual C# 2013 06177-179-0039547-02399
Microsoft Visual C# 2013

Visual C++ 2013 06177-179-0039547-02399
Microsoft Visual C++ 2013

Visual F# 2013 06177-179-0039547-02399
Microsoft Visual F# 2013

Visual Studio 2013 Code Analysis Spell Checker 06177-179-0039547-02399
Microsoft® Visual Studio® 2013 Code Analysis Spell Checker

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.

Windows Phone SDK 8.0 - ENU 06177-179-0039547-02399
Windows Phone SDK 8.0 - ENU

Application Insights Tools for Visual Studio Package 1.0
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 12.4.51016.0
Microsoft Web Developer Tools contains the following components:
Support for creating and opening ASP.NET web projects
Browser Link: A communication channel between Visual Studio and browsers
Editor extensions for HTML, CSS, and JavaScript
Page Inspector: Inspection tool for ASP.NET web projects
Scaffolding: A framework for building and running code generators
Server Explorer extensions for Microsoft Azure Websites
Web publishing: Extensions for publishing ASP.NET web projects to hosting providers, on-premises servers, or Microsoft Azure

ASP.NET Web Frameworks and Tools 2012.2 4.1.21001.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.21010.0
For additional information, visit http://www.asp.net/

Common Azure Tools 1.3
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Devart dotConnect for MySQL 8.3.359.0
Devart dotConnect for MySQL
Copyright 2002 - 2015 Devart. All rights reserved.
Web: www.devart.com/dotconnect/mysql
Support: [email protected]

Devart Entity Developer 5.7.556.0
Devart Entity Developer
Copyright © 2008-2015 Devart. All rights reserved.
Web: www.devart.com/entitydeveloper
Support: [email protected]

Git Source Control Provider 1.0.0.0


InstallShield Limited Edition
InstallShield. For more information visit the Flexera Software website at <http://www.FlexeraSoftware.com>. Copyright © 2013 Flexera Software LLC. All Rights Reserved.

Microsoft Advertising SDK for Windows Phone
Microsoft Advertising SDK for Windows Phone
Build

Microsoft Azure Mobile Services Tools 1.3
Microsoft Azure Mobile Services Tools

Microsoft Azure Tools 2.4
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.4.20730.1601

NuGet Package Manager 2.8.50926.663
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Office Developer Tools for Visual Studio 2013 ENU 12.0.30626
Microsoft Office Developer Tools for Visual Studio 2013 ENU

PowerShell Tools 1.3
Provides file classification services using PowerShell

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Data Tools 12.0.41012.0
Microsoft SQL Server Data Tools

Windows Phone 8.1 SDK Integration 1.0
This package integrates the tools for the Windows Phone 8.1 SDK into the menus and controls of Visual Studio.

Workflow Manager Tools 1.0 1.0
This package contains the necessary Visual Studio integration components for Workflow Manager.

Xamarin 3.9.236.0 (d6a2cae)
Visual Studio extension to enable development for Xamarin.iOS and Xamarin.Android.

Xamarin.Android 4.20.0.34 (49a04b966feb40dfdba49d57ba16249b66d606a6)
Visual Studio plugin to enable development for Xamarin.Android.

Xamarin.iOS 8.6.0.0 (eb24bdcf5cba2c12b673a07e0a8cce368b9563b3)
Visual Studio extension to enable development for Xamarin.iOS.

Xamarin.iOS Unified Migration 1.0
Automated migration for Xamarin iOS Classic projects to Unified

Git Extensions
Git Extensions is a graphical interface for Git
For more information about Git Extensions, see the Git Extensions website at
http://code.google.com/p/gitextensions/
Copyright © 2012 Henk Westhuis

I got the table to show up by re-running the solution.

I'm not sure why the IdentityRoles table didn't get generate initially.

Anyway, for people wanting to do method A you'll need to know the schema for the new identity tables, which isn't included in the Identity 2 table script.

CREATE TABLE `IdentityRoles` (
`Id` varchar(128) NOT NULL,
`Name` longtext NOT NULL,
PRIMARY KEY (`Id`)
)

CREATE TABLE `IdentityUsers` (
`Id` varchar(128) NOT NULL,
`Email` longtext,
`EmailConfirmed` bit(1) NOT NULL,
`PasswordHash` longtext,
`SecurityStamp` longtext,
`PhoneNumber` longtext,
`PhoneNumberConfirmed` bit(1) NOT NULL,
`TwoFactorEnabled` bit(1) NOT NULL,
`LockoutEndDateUtc` datetime DEFAULT NULL,
`LockoutEnabled` bit(1) NOT NULL,
`AccessFailedCount` int(11) NOT NULL,
`UserName` longtext NOT NULL,
PRIMARY KEY (`Id`)
)