How do I fix this error mysqlconnector.mysqlexception: 'column 'name' cannot be null'

See more:

C#

dapper

MySQL-Connector

, +

I am trying to pass data into a phpmyadmin database(Xampp) using a stored procedure from the database, i also intend to map my object in my code to the parameter from the stored procedure using dapper ORM. Now, when i run the code to do this, i keep getting the error above, i tried debugging i didnt see any bug in my code, i figured dapper is not passing the object from my data model into the stored procedure parameter, while debugging i was able to confirm that the object from my model was passed into the dynamic parameter object which i passed into the connection.execute command.

What I have tried:

using (IDbConnection connection = new MySqlConnector.MySqlConnection(GlobalConfig.CnnString(connectionS)))
{
foreach (OrganizationMembers model in models)
{

var p = new DynamicParameters();

string myName = "@Name";
p.Add(myName, model.Name);
p.Add("@Age", model.Age);
p.Add("@Class", model.Class);


connection.Query("organizationmembers_insert", p, commandType: CommandType.StoredProcedure);//this is where it throws an error saying the name column //cannot be null

model.Id = connection.Query<int>("dbo.SpGetId").First();

}

}// the name column in the database was indeed set as not null, but a value //was passed in the object when i ran the query