I am writting a method that populates a dataclass from a TableAdapter.

Object of type System.Int32 cannot be converted to type System.Boolean

public Model.PayrollEmpSalarySetup Get(string Record_Id)
        {
            Model.PayrollEmpSalarySetup iObject = null;
            DBManager dbManager = null;
            IDataReader iReader = null;
            string sql = string.Empty;

            try
            {
                sql = @"SELECT SALARY_SETUP_ID, EMP_NO, CREATE_DATE, FROM_DATE, TO_DATE, GROSS_SALARY, BASIC_SAL, HRA_SAL, MED_ALL_SAL, CONVEYANCE_SAL, 
                    OTHER_ALL_SAL, PF_SAL, PT_SAL, NET_SALARY, IS_ACTIVE, MARK_DELETED, LOGIN_ID, SYSTEM_IP,TRANS_TIME
                    FROM dbo.PAYROLL_EMPLOYEE_SALARY_SETUP WITH(NOLOCK) WHERE MARK_DELETED=0 AND EMP_NO=" + Record_Id;

                switch (Constants.DBEngine)
                {
                    case (int)DataProvider.SqlServer:
                        dbManager = new DBManager();
                        dbManager.ConnectionString = Constants.ConnectionString;
                        dbManager.ProviderType = DataProvider.SqlServer;
                        break;
                }
                dbManager.Open();
                dbManager.Command.CommandTimeout = Constants.CommandTimeOut;
                dbManager.Command.CommandText = sql;
                dbManager.Command.Connection = dbManager.Connection;
                iReader = dbManager.Command.ExecuteReader();
                iObject = iReader.SingleOrDefault<Model.PayrollEmpSalarySetup>();
            }
            catch (Exception Exp)
            {
                throw Exp;
            }
            finally
            {
                if (iReader != null)
                    iReader.Close();
                if (dbManager != null)
                    dbManager.Close();
            }
            return iObject;
        }