此计数为6的SqlParameterCollection的索引6无效

本文关键字：索引 无效 SqlParameterCollection | 更新日期: 2023-09-27 18:26:55

映射类

public class cAdministratorMap : ClassMap<cAdministrator>
{
    public cAdministratorMap()
    {
        Table("Administrators");
        CompositeId<cAdministratorsKey>(c => c.Key)
            .KeyProperty(x => x.Client_id, "client_id")
            .KeyProperty(x => x.Start_date, kp => kp.ColumnName("start_date").Type(DbType.Date.ToString()))
            .KeyProperty(x => x.Adm_type, kp => kp.ColumnName("adm_type").Type(DbType.AnsiString.ToString()));
        Map(x => x.Person_id, "person_id").Not.Insert().Not.Update();
        Map(x => x.end_date).Column("end_date");
        Map(x => x.description).Column("description").Length(200);
        References(x => x.Person).Column("person_id");
        References(x => x.Cliente).Column("client_id");
    }
}

我得到以下错误

此SqlParameterCollection的索引6无效，计数=6

请帮助

此计数为6的SqlParameterCollection的索引6无效

Client Id被映射两次，一次在您的cAdministratorsKey映射中，另一次在Cliente mapping中。

删除Cliente映射并更改cAdministratorsKey映射以包含对Cliente属性的引用，如下所示：

  CompositeId<cAdministratorsKey>(c => c.Key)
        .KeyReference(x => x.Cliente, "client_id") // Changed to KeyReference
        .KeyProperty(x => x.Start_date, kp => kp.ColumnName("start_date").Type(DbType.Date.ToString()))
        .KeyProperty(x => x.Adm_type, kp => kp.ColumnName("adm_type").Type(DbType.AnsiString.ToString()));
  // References(x => x.Cliente).Column("client_id"); Removed as not needed

这样可以消除重复并解决您的问题。

相关文章：