Hi everyone.
I googled it a lot but i couldn't find a satisfactory answer to my issue.
how should i map always encrypted columns in fluent nhibernate?
i have a colun encrypted. it is ok with stored procs (i added Column
Encryption Setting=enabled to my connectionstring)
but with insert or updates i get this error;
SqlException: Operand type clash: varchar(8000) encrypted with
(encryption_type = 'DETERMINISTIC', encryption_algorithm_name =
'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1',
column_encryption_key_database_name = 'CC_DEMSA') collation_name =
'SQL_Latin1_General_CP1254_CI_AS' is incompatible with nvarchar(50)
encrypted with (encryption_type = 'DETERMINISTIC',
encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256',
column_encryption_key_name = 'CEK_Auto1',
column_encryption_key_database_name = 'CC_DEMSA')
Statement(s) could not be prepared.
map.cs;
public class TbTelFaxGsmMap : ClassMap<TbTelFaxGsm> {
public TbTelFaxGsmMap() {
Table("TbTelFaxGsm");
LazyLoad();
Id(x => x.InTelFaxGsmId).GeneratedBy.Identity().Column("InTelFaxGsmId");
Map(x => x.StCustNo).Column("StCustNo");
Map(x => x.InTfgType).Column("InTfgType");
Map(x => x.InRecordOrder).Column("InRecordOrder");
Map(x => x.BoTrue).Column("BoTrue");
Map(x => x.InTelCountryCode).Column("InTelCountryCode");
Map(x => x.InTelCityCode).Column("InTelCityCode");
Map(x => x.StTfg).Column("StTfg");
Map(x => x.StNotes).Column("StNotes");
Map(x => x.InIsDisabled).Column("InIsDisabled");
}
}
domain.cs
public class TbTelFaxGsm {
public virtual int InTelFaxGsmId { get; set; }
public virtual string StCustNo { get; set; }
public virtual byte? InTfgType { get; set; }
public virtual byte? InRecordOrder { get; set; }
public virtual bool? BoTrue { get; set; }
public virtual int? InTelCountryCode { get; set; }
public virtual int? InTelCityCode { get; set; }
public virtual string StTfg { get; set; }
public virtual string StNotes { get; set; }
public virtual int? InIsDisabled { get; set; }
}
Thanks
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nhusers/24bba107-b9ad-462b-b2e5-76330fd7322an%40googlegroups.com.
