Here is the Query:
Code: Select all
var loanBailmanRepository = _uow.GetRepository<LoanBailman>();
var query = loanBailmanRepository.GetQueryable().Where(x => x.LbmBailmanRefno == customerNumber)
.Select(x => new AccountBaseDto(IncludeBalanceForRestrictedAccounts, false)
{
...,
AccNo = x.Account.AccNo, //sorunlu
...,
}
}).Skip(0).Take(20).ToList();
Code: Select all
Before
modelBuilder.Entity<LoanBailman>().Property<System.Nullable<long>>(x => x.LbmAccNo).HasColumnName(@"LBM_ACC_NO").HasColumnType(@"NUMBER").ValueGeneratedNever();
modelBuilder.Entity<Account>().HasMany(x => x.LoanBailmen).WithOne(op => op.Account).OnDelete(DeleteBehavior.Cascade).IsRequired(false).HasForeignKey(@"LbmAccNo");
modelBuilder.Entity<LoanBailman>().HasOne(x => x.Account).WithMany(op => op.LoanBailmen).OnDelete(DeleteBehavior.Cascade).IsRequired(false).HasForeignKey(@"LbmAccNo");
After (No Errors);
modelBuilder.Entity<LoanBailman>().Property<long>(x => x.LbmAccNo).HasColumnName(@"LBM_ACC_NO").HasColumnType(@"NUMBER").IsRequired().ValueGeneratedNever();
modelBuilder.Entity<Account>().HasMany(x => x.LoanBailmen).WithOne(op => op.Account).OnDelete(DeleteBehavior.Cascade).IsRequired(true).HasForeignKey(@"LbmAccNo");
modelBuilder.Entity<LoanBailman>().HasOne(x => x.Account).WithMany(op => op.LoanBailmen).OnDelete(DeleteBehavior.Cascade).IsRequired(true).HasForeignKey(@"LbmAccNo");
Code: Select all
public class LoanBailman {
public LoanBailman()
{
OnCreated();
}
[System.ComponentModel.DataAnnotations.Key]
[System.ComponentModel.DataAnnotations.Required()]
public virtual long LbmMyrowid
{
get;
set;
}
public virtual Nullable<long> LbmAccNo
{
get;
set;
}
}
An exception occurred while reading a database value for property 'LoanBailman.LbmAccNo'. The expected type was 'System.Nullable`1[System.Int64]' but the actual value was of type 'System.String'
When I change my class to :
Code: Select all
public class LoanBailman {
public LoanBailman()
{
OnCreated();
}
[System.ComponentModel.DataAnnotations.Key]
[System.ComponentModel.DataAnnotations.Required()]
public virtual long LbmMyrowid
{
get;
set;
}
public virtual long LbmAccNo
{
get;
set;
}
}