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);
}
