Data type Converion problem

Question

The specified cast from a materialized 'System.Int64' type to a nullable 'System.Int32' type is not valid. I have used String data type in Database as well as the model but if check-in where the condition that time this Error will occur .please help me.

Puneet Kankar · Answer

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.

Salman Beg · Answer

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

Kalyani Shevale · Answer

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.

Salman Beg · Answer

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.