Invalid Column name ID-Entity Framework

c# entity-framework-6

Question

I have table in my database with this structure:

CREATE TABLE [dbo].[FDTransaction]
(
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FamilyId] [int] NULL,
    [BankId] [int] NULL,
    [Account_No] [numeric](25, 0) NULL,
    [Amount] [int] NULL,
    [Interest_Percent] [decimal](18, 0) NULL,
    [Tenure] [int] NULL,
    [MaturityDate] [datetime] NULL,
    [InterestAmount] [int] NULL,

    CONSTRAINT [PK_FDTransaction] 
        PRIMARY KEY CLUSTERED ([ID] ASC)
) ON [PRIMARY]

I have a model class which represents the database table in the code:

 public class FDTransaction
 {
        [Key]
        public int ID { get; set; }     
        public int Familyid { get; set; }
        public int BankId { get; set; }
        public decimal Account_No { get; set; }
        public int Amount { get; set; }
        public double Interest_Percent { get; set; }
        public int Tenure { get; set; }
        public DateTime MaturityDate { get; set; }
        public int interestAmount { get; set; }
}

I am getting an error when I am adding a record in table at below mentioned line.

dbentities.Transactions.Add(transaction);

Also below is the error stack.

       StackTrace:
            at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
            at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.<Update>b__2(UpdateTranslator ut)
            at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction)
            at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update()
            at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStore>b__35()
            at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
            at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
            at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.<SaveChangesInternal>b__27()
            at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
            at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
            at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options)
            at System.Data.Entity.Internal.InternalContext.SaveChanges()
       InnerException: System.Data.SqlClient.SqlException
            HResult=-2146232060
            Message=Invalid column name 'ID'.
Invalid column name 'ID'.
            Source=.Net SqlClient Data Provider
            ErrorCode=-2146232060
            Class=16
            LineNumber=5
            Number=207

As mentioned above, I do have column ID in table. Also I have property ID in class FDTransaction. Still I am not able to add row in the database.

1
2
4/1/2018 12:49:50 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Since the ID column is an IDENTITY column, you need to add another attribute ([DatabaseGenerated]) to your ID field in the model class to tell EF that this is an IDENTITY column and it doesn't need to provide a value - SQL Server will set the value when you insert the row.

Try this:

public class FDTransaction
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ID { get; set; }     
    .... (your other properties here, same as before) ......  
}
0
4/1/2018 1:40:36 PM

Related Questions

Select * from Entities where Id = (select max(Id) from Entities) in Entity Framework

I think from a simplicity point of view, this should be same result but faster as does not require two round trips through EF to sql server, you always want to execute query as few times as possible for latency, as the Id field is primary key and indexed, should be performant...using(var db = new DataContext()) { var maxEntity = db.Entities.OrderBy...
entity-framework
asked by Gerard

'OrganizationStructure ID' is an invalid column name in Entity Framework.

What I have figured out is when you have an ICollection that references a table and there is no column that it can figure out, it creates one for you to try to make the connection between the tables. This specifically happens with ICollection and has driven me "batty" trying to figure it out.
entity-framework
asked by drewid

Invalid Column Name error in Entity Framework 5

In short, consider making your [Required] DateTime fields Nullable (DateTime?). If you provide more information about the stacktrace and any Initialization code it would be helpful....[Required] public DateTime? ClientStartDate { get; set; }
c# ef-code-first entity-framework
asked by kingdango

Entity Framework : Invalid Column after removing the column

I used to also remove and re-add table, but never like this. What I rather do. I close model. right click and open as XML and them manually remove this reference. So it keeps my multiple diagrams within one model same and also my defined colors.
c# entity-framework
asked by Petr J

Entity Framework "Invalid Column Name"

I had an error in my mapping class from copy/paste situation. As you can see, mapped ...TranferredToEVP... to 3 different columns. I was getting an "invalid column name" on the last column ...TranferredToGUID... but was looking for ...TranferredToGUID1.... Hope this helps. ...this.Property(t => t.TransferredToEVP).HasColumnName("TransferredToEVP");...
ef-code-first entity-framework
asked by Amy Jonas

Get field from dynamically/programatically named column name with Entity Framework

You could use reflection to get a list of properties. Look at the GetProperties() method on System.Type....http://msdn.microsoft.com/en-us/library/aky14axb(v=vs.110).aspx...public PropertyInfo[] GetProperties() ...You could then use LINQ to find a property that maches the one you want:...var myEntity = DatabaseFunctions.DatabaseClient .tbl_Mete...
c# entity-framework entity-framework-6
asked by Dismissile

Entity Framework - Database First - Invalid column name error

Check this out...[Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public Guid BusinessID { get; set; } ...In your query, change ...Where... and ...SingleOrDefault... to:...x = cntx.Application.SingleOrDefault(m => m.ApplicationID == id); ...Hope it helps
database-first dbset entity-framework-6
asked by Daniel Corzo

Invalid Column name when using savechanges() in entity framework

In may case, we found defining the database elemenents in the context fixed the issue. ...protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.HasDefaultSchema("database_schema"); modelBuilder.Entity<EntityNameInModel>().ToTable("table_in_database").HasKey(ats => ats.id); mo...
asp.net-mvc ef-database-first entity-framework entity-framework-6 sql-server
asked by Ashley

"Invalid column name" with Entity Framework migrations

The work-around provided by @scsimon translates to the SQL-statement...Sql("EXEC('update dbo.Models set Col3 = Col2')"); ...and script...ALTER TABLE [dbo].[Models] ADD [Col3] [int] NOT NULL DEFAULT 0 EXEC('update dbo.Models set Col3 = Col2') ...and works fine....I prefer this method, as I expect it to be less fulnerable to EF modifications.
ef-migrations entity-framework-6 sql-server-2014
asked by R. Schreurs

Entity Framework - Invalid Column Name 'User_ID"

Try adding the foreign key attribute to the ICollection navigation property:...[ForeignKey("UserId")] public virtual ICollection<ClassRoom> AvailableClassRooms { get; set; } ...Since you've changed the naming convention you must set it on both sides of the relationship. ...I usually prefer to do this using EF's fluent API as it's more flexible and...
asp.net-mvc-5 c# entity-framework-6 entity-framework-6.2 entity-relationship
asked by olitee

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