EF6: ORA-00910: specified length too long for its datatype

EF6, Code-First, enable-migrations, "Unable to load the specified metadata resource"

I had a similar problem but with a different outcome. As it took too many hours to debug, here are some hints....The "Unable to load the specified metadata resource." error is related to your connection strings....Start by checking the connection string in your project where you have all your entities....Make sure the connection string is for a ...

EF6 executing a long running stored procedure gets timeout errors

I believe this article may have the answer but I won't know until my job runs tonight. I will update this answer if it succeeds:...http://entityframework.codeplex.com/discussions/454994...Which says:...As part of the Connection Resiliency work we changed the default behavior of certain APIs that can produce side effects to start using transact...

Specified key was too long; max key length is 767 bytes Mysql error in Entity Framework 6

If you're using ASP.NET Identity then there are 3 places where this is happening...In the migration history table...The Name property of IdentityRole...The Username and Email property of ApplicationUser...Most articles I came across has a solution that basically reduce the length of Username and Email to 128 character. However, i found this is unac...

EF6: Schema specified is not valid; ambiguous mapping

After hours of desperate searching what’s wrong I finally found a solution. The problem is that I am composing MEF parts twice. Every time for each phase in my workflow and I think the same library is therefore loaded twice in the AppDomain. EF then sees two same classes in the same namespace....The solution was very simple – in my code where I...

Inserting record in SQL table with timestamp datatype

For EF Core 2.0 (and propably EF Core 1.0 as well) you have to specify timestamp/version property inside DbContext/OnModelCreating mehod....Below you can find sample specification for the "Request" type....modelBuilder.Entity<Request>(entity => { entity.ToTable("Requests"); // Depends on your table name entity.HasKey(e => e.Req...

Mysql Entity Framework issue - Specified key was too long; max key length is 3072 bytes

I used official MySql provider ...MySql.Data.EntityFrameworkCore... which is in pre-release state and has some troubles with migrations. Then I changed to ...Pomelo.EntityFrameworkCore.MySql... and updated database without any errors.

Entity Framework Core: FK with Different DataType than PK

In EF Core 2.1 you can use value conversions, i.e. ...entityBuilder.Property(c => c.Id).HasConversion<string>(); ...where the generic string is the database type and the destination is the model type. You can read further on ...https://docs.microsoft.com/es-es/ef/core/modeling/value-conversions

Entity Framework 6 - ORA-00932 while joining with ToString

Sadly ....ToString()... isn't implemented that well in Oracle Entity Framework. So I got a workaround by this ...SO question accepted answer.... Installing ...EntityFramework.Functions... Nuget Package and using the ...TO_NCHAR... built in Oracle function did the trick as following:...public static class OracleFunctions { [Function(FunctionType...

EF Core AddAsync and SaveChangesAsync slightly slower after application is idle for a long time

Usually all providers have some implementations to prune idle connections after a period of idle time. ...The first command takes a bit more time to create and open the connection. The next commands will use the pooled connection and they are faster. Then after being idle for a specific amount of time, providers prune the pool and close idle connec...

How does the compiler know what datatype the lambda expression should be

The accepted answer is a reasonable explanation, but I thought I might provide a little more detail....So lets say you are using FirstOrDefault on a DbSet. ...DbContext.Foos.FirstOrDefault(x=> x.Bar == true);...First off, I hope you would not write that. If you want to ask "is it raining?" do you ask "is it raining?" or do you ask "is the statement...