Entity Framework 7 Invalid Column Name

c# entity-framework entity-framework-core


I'm creating EF7 mappings for an existing database and I'm getting an "Invalid column name" error. The code that is throwing the error is:

public class DepositContext : DbContext
    public DbSet<tblBatch> Batches { get; set; }
    public DbSet<tblTransaction> Transactions { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
        modelBuilder.Entity<tblBatch>().HasKey(b => b.BatchID);

        modelBuilder.Entity<tblTransaction>().HasKey(t => t.TransactionID);

        modelBuilder.Entity<tblBatch>().HasMany(b => b.tblTransactions).WithOne().HasForeignKey(t => t.fBatchID);

public class tblBatch
    public int BatchID { get; set; }
    public int? fDepositID { get; set; }
    public Guid BRN { get; set; }
    public string BCN { get; set; }
    public decimal? BCT { get; set; }
    public string BatchFileName { get; set; }

    public List<tblTransaction> tblTransactions { get; set; }

public class tblTransaction
    public int TransactionID { get; set; }
    public string TRN { get; set; }
    public string TransactionStatus { get; set; }

    public int fBatchID { get; set; }
    public tblBatch tblBatch { get; set; }

This is throwing a Invalid column name 'tblBatchBatchID1'. And when I use SQL Profiler to see what is being sent to the database, it is:

exec sp_executesql N'SELECT [t].[TransactionID], [t].[fBatchID], [t].[TRN], [t].[TransactionStatus], [t].[tblBatchBatchID1]
FROM [tblTransaction] AS [t]
    SELECT DISTINCT TOP(1) [b].[BatchID]
    FROM [tblBatch] AS [b]
    WHERE [b].[BatchID] = @__BatchId_0
) AS [b] ON [t].[fBatchID] = [b].[BatchID]
ORDER BY [b].[BatchID]',N'@__BatchId_0 int',@__BatchId_0=37

Does anybody know how to fix this?

4/4/2016 9:45:14 PM

Popular Answer

There were some bugs in EF RC1 that produced the wrong column name in query generation. See this list of bugs that might be related to your issue.

You can attempt to work around this by explicitly setting the column name.

modelBuilder.Entity<tblBatch>().Property(e => e.BatchID).HasColumnName("BatchID");

If you're feeling brave, you can try upgrading to RC2 nightlies of EF Core and see if the issue is fixed there.

4/5/2016 1:00:32 AM

Related Questions


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