Scaffolding Identity framework mvc core
I'm having trouble to recreate my C# project on a virtual machine.
Basically, I've copied my project, opened it on my virtual machine. Scaffolded so I get the SQL database to talk to my project on the virtual machine after I manually created some tables in SQL.
PROBLEM: How do I get the Identity framework sql data-Tables into my virtual machien SQL tables section? I would like the tables highlited in yellow on the left (my original machine sql) to also be present on my virtual machine sql, the right side of the picture.
How can I get this automatically? Nuget for identity framework is downloaded but I guess there is some sort of scaffolding or similar?
If I understand you correctly you want to create tables for Identity. You have 2 options here:
Use Migrations like described in this post
Or just generate SQL scripts for Identity tables using EF Core or SQL Management Studio, since you have SQL Management Studio according to you screen you can use it to generate Script for particular tables using
Task->Generate Scripts...while right click on your Database.
And then just choose the tables you need and then choose Save to new query window.
- If database not very huge, you can also use
Task->Back up...save it on your machine. Then copy this backup to virtual machine and restore it there usingRestore Database. You can even just use SQL for this like described here.
- How to properly delete data from a table and chain the deletion
- Find procedure name in all other procedures
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Running multiple SQL-Statements with Python
- Using rangeBetween considering months rather than days in PySpark
- How to find databases which accessible to me in Sql server?
- data return incorrect using left join with 2 tables
- Repeat rows specified number of times in PostgreSQL
- How to visualize database tables in postgresql using pgAdmin?
- Odata override behaviour of orderby
- Unable to open BCP host data-file
- How to join parent object with nested array using OpenJson SQL
- batch update a column using sql
- Queries using LIKE wildcards in sql server
- Conditional aggregation in SQL: display condition-dependent count in percentage?
- Parsing JSON with Oracle SQL without knowing incoming field names
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
- output sql data to html with hyperlink
- Update all column names to be lowercase
- SQL Server pivoting on data without an aggregate
- Flagging a row in new column based on conditions on previous and current rows
- replace or remove characters and then cast to decimal
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Query to get only numbers from a string
- SQL grouping result to half hour
- table is specified twice both as a target for INSERT and as separate source of data
- SQL to JSON Need Bracket for Array that can have multiple rows