public async Task <object> InsertRecordReturnsRowsAffected() { object returnValue = new object(); string sql = "INSERT INTO Country(CountryId,IsDeleted,CountryAbbreviation,CountryName,CountryCallingCode)"; sql += "VALUES(@CountryId,@IsDeleted,@CountryAbbreviation,@CountryName,@CountryCallingCode)"; DatabaseWrapper database = new DatabaseWrapper(); database.InitializeWithConfigurationFile(Config.ConnectionString); try { returnValue = await database .CreateCommand(sql) .AddParameter("@CountryId", 256) .AddParameter("@IsDeleted", false) .AddParameter("@CountryAbbreviation", "IND") .AddParameter("@CountryName", "INDIA") .AddParameter("@CountryCallingCode", "+91") .NonQueryAsync(); } catch (SqlException ex) { returnValue = GetCustomExceptionOn(ex); } catch (Exception ex) { returnValue = GetCustomExceptionOn(ex); } finally { database.Connection.Close(); } Console.WriteLine("Rows affected: " + (int)returnValue); return(returnValue); }