Data type Converion problem

If both are string then that error should not come. You need to double check. Thanks.

+2

I think the data type of the columns inside your database table is Int32 but your data model has double. You need to change the data types of your data models to int. By materialized it means the type it got when it ran the query on the database.

+2

Kalyani Shevale7y ago

below code

var data = new BussinessLogic.MasterBasic.FeeStructrueTransaction(new Repository.MasterBasic.FeeStructureTransactionRepo(new DatabaseContext.CRMContext())).GetAllFeeStructureTransaction().Where(a => a.BankTransactionNo == model.FormFeeUnique_Transaction_ID).FirstOrDefault();

BankTransactionNo this is defined as String in DAtabase as well as Model

model.FormFeeUnique_Transaction_ID this is defined string in model

but this error occured.

+1

Salman Beg7y ago

Hi. Int64 size is different and when you try to incorporate/assign the value to Int32 then such type of error will arise. But as you said you are using string then you need to check at your end by debugging. Thanks.

+2