copy a table to another and add a column that is the tablename of the source

I want to copy some tables who all have the same prefix into one table. The destination table should have on column more then the source, that is the name of the source table. I tried this : INSERT INTO `tbl_dest` (`nr`,`n1`,`n2`,`n3`,`n4`,`n5`,`table`) SELECT `a`.`nr`, `a`.`n1`, `a`.`n2`, `a`.`n3`, `a`.`n4`, `a`.`n5`, `b`.`table` FROM `tbl_src` `a`, `INFORMATION_SCHEMA.TABLES`.`TABLE_NAME` `b`…

When using ASP.NET core Identity, it is better to extend the User class or write separate entities that relate to it [on hold]

I want to use the Identity system provided by ASP.NET core. Most tutorials I read extend the User class by adding custom properties like the following: public class ApplicationUser : IdentityUser { public string FirstName { get; set; } public string LastName { get; set; } // etc… } This seems fine when you only…