Unknown column 'Extent1.Email' in 'field list'

asp.net asp.net-identity entity-framework-6 mysql

Question

I am trying to implement ASP.NET Identity with a MySql database. After encountering some difficulties, which seemed to be related to the Identity version I was using, I updated it, and now I have different errors I am dealing with.

Initially it stated that it could not find the XXX.aspnetusers table, I found I should add the below code to map it to how the table is created in the MySql database.

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);
    modelBuilder.Entity<ApplicationUser>().ToTable("my_aspnet_users");
}

Now that fixed the error, now I am facing this issue:

enter image description here

Looking at the database, I can see that indeed the Email field is not created, I want to know why aren't all the IdentityUser fields added?

1
1
9/18/2016 2:38:12 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You have to map each and every property as shown below.

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);
    modelBuilder.Entity<ApplicationUser>().ToTable("my_aspnet_users");
    modelBuilder.Entity<ApplicationUser>().Property(t => t.Email).HasColumnName("Email");
    //map other properties too    
}
1
9/18/2016 3:11:11 PM

Related Questions

Entity Framework options to map list of strings or list of int (List<string>)

Although I do not like to answer my own question, but here is what solved my problem:...After I found this link about ...Complex Types... I tried several implementations, and after some headache I ended up with this....The List values get stored as a string on the table directly, so it's not required to perform several joins in order to get the lis...
entity-framework list mapping orm
asked by Bernhard Kircher

"The * field is required" when the EF object has the field already

You should mark with required attribute simple properties, not navigation properties:...[Table("PbnJobs")] public abstract class PbnJob : Job { public virtual PbnSite Site{ get; set; } [ForeignKey("Site")] [Required] public int SiteId { get; set; } } ...In this case Required is not useful cause your foreign key property is not null...
c# ef-code-first entity-framework entity-framework-6
asked by Kirill Bestemyanov

ASP.NET MVC Details view with many display fields but a single editable field

This is probably not the case but since i can't tell from the sample code, do you have the ...Html.BeginForm(){}... block around the model that you are trying to post? Also maybe try changing the ...<button>... tag to ...<input type='submit' value='save status'/>... instead
asp.net-mvc asp.net-mvc-viewmodel entity-framework-6 repository-pattern
asked by Marco

ORA-00904: "Extent1"."IsModified": invalid identifier,

Based on what I see, I can say that those rows are for UOW(Unit Of Work) implementation....Basically those fields are used for Paging - RowNumberValue, IsNew is used to mark an entity which was added and IsModified is for an entity pending update....If this answer is still correct then ef6 is not supported by ODP ...https://stackoverflow.com/a/2330...
ef-code-first entity-framework-6
asked by radu florescu

Unknown column 'Extent1.Discriminator' in 'where clause'

Extent1 is a table alias used by entity framework when it constructs the underlying sql statements. The error means that EF is either not configured correctly or misinterprets your database structure....You need to analyise the underlying query it generates and determine why EF us3s a field it is not supposed to. Probably a relationship between 2 t...
asp.net asp.net-identity entity-framework-6 membership-provider mysql
asked by Shadow

select from a list with field name and field value with linq (similar to select command)

After searching I found the Answer ,Answer is:... public class SearchField { public string Name { get; set; } public string @Value { get; set; } //public string Operator { get; set; } public SearchField(string Name, string @Value) { this.Name = Name; this.@Value = @Value; ...
c# entity-framework-6 linq sql-server
asked by Hootan.Ghiasi

Unknown column in field list - After MySQL changes

Found the answer! I'm not entirely sure why the error was occurring! Anyway.....I have two entities:...Header and Group....I have a foreign key in my header entity which create a link with group. It said that one header can have one group. Which after I reviewed, was incorrect. One header can have many groups. So I changed the foreign key from this...
c# entity-framework-6 linq mysql mysql-connector
asked by Andrew Kilburn

EntityFramework6 - Error 42703: column Extent1... not found

As @DavidG said in the above comment, you have a navigation property but no foreign key property for that navigation. ...You need to add a FK property and mark the navigation property with [ForeignKey("keyname")] attribute:...[Table("tbl_process", Schema = "public")] public class Process { [Key] public int id { get; set; } public strin...
c# entity-framework-6 linq npgsql postgresql
asked by Dejan Janjušević

Get selected fields on a list using a LINQ query

Don't select all records first and then filtered your data....If you use ....ToList<DataControllers.TBLM_PRODUCT>()... then it can select all records. So instead of this you can select your columns at the time of query fired to database....If your ...TBLM_PRODUCT... is of any collection type like ...IEnumerable<>... or ...IQueryable<>... then,...us...
c# entity-framework-6 linq linq-query-syntax sql-server
asked by er-sho

Prepare a List of fields and displaynames for each DbSet in DbContext

You could use reflection:...typeof(YourContext) .GetProperties() .Where(prop => prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(DbSet<>)) .SelectMany(dbSet => dbSet.PropertyType.GetGenericArguments() .Single() .GetProperties() .Select(prop => new [] { prop.Declari...
.net-4.0 asp.net-mvc-5 c# ef-database-first entity-framework-6
asked by Johnathan Barclay

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow