在ReferentialConstraint从属属性映射到一个存储生成列 [英] A dependent property in a ReferentialConstraint is mapped to a store-generated column

问题描述

写入数据库，当我得到这个错误：

  

在ReferentialConstraint从属属性映射到一个
  存储生成列。专栏：PaymentId

。

 公共BOOL PayForItem（INT terminalId，双paymentAmount，
      eNums.MasterCategoryEnum mastercategoryEnum，诠释的CategoryId，诠释CategoryItemId）
    {        使用（VAR dbEntities =新DatabaseAccess.Schema.EntityModel（））
        {
            INT pinnumber = 0;
            长pinid = 1; // getPinId（terminalId，楼盘pinnumber）;
            VAR支付=新DatabaseAccess.Schema.Payment（）;
            payment.CategoryId =类别ID;
            payment.ItemCategoryId = CategoryItemId;
            payment.PaymentAmount =（十进制）paymentAmount;
            payment.TerminalId = terminalId;
            payment.PinId = pinid;            payment.HSBCResponse code =;
            payment.DateActivated = DateTime.Now;
            payment.PaymentString =付款;
            payment.PromotionalOfferId = 1;
            payment.PaymentStatusId =（INT）eNums.PaymentStatus.Paid;            //payment.PaymentId = 1;            dbEntities.AddToPayments（付款）;
            dbEntities.SaveChanges（）;
        }
        返回true;
    }
 

模式是：

解决方案

有没有可能是你定义你的表之间的不良列的关系？不同的列和一个被定为autonumeric。

这发生在我身上。

I get this error when writing to the database:

A dependent property in a ReferentialConstraint is mapped to a store-generated column. Column: 'PaymentId'.

public bool PayForItem(int terminalId, double paymentAmount, 
      eNums.MasterCategoryEnum  mastercategoryEnum, int CategoryId, int CategoryItemId)
    {

        using (var dbEntities = new DatabaseAccess.Schema.EntityModel())
        {
            int pinnumber = 0;
            long pinid = 1; //getPinId(terminalId,ref pinnumber) ;
            var payment = new DatabaseAccess.Schema.Payment();
            payment.CategoryId = CategoryId;
            payment.ItemCategoryId = CategoryItemId;
            payment.PaymentAmount = (decimal)paymentAmount;
            payment.TerminalId = terminalId;
            payment.PinId = pinid;

            payment.HSBCResponseCode = "";
            payment.DateActivated = DateTime.Now;
            payment.PaymentString = "Payment";
            payment.PromotionalOfferId = 1;
            payment.PaymentStatusId = (int)eNums.PaymentStatus.Paid;

            //payment.PaymentId = 1;

            dbEntities.AddToPayments(payment);
            dbEntities.SaveChanges();
        }
        return true;
    }

The schema is:

解决方案

Is it possible that you defined a bad column relation between your tables? different columns and one was set as autonumeric.

It happened to me.

这篇关于在ReferentialConstraint从属属性映射到一个存储生成列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！