The SqlParameterCollection only accepts non-null SqlParameter type objects, not SqlParameter objects. #10923

5 Answer(s)

• 

  0

  ismcagdas created 2 years ago

  Support Team

  Hi,

  I think this is not related to AspNet Zero but you can solve it by following https://github.com/dotnet/efcore/issues/16812#issuecomment-516013245

  Save Cancel
• 

  0

  sumitshah created 2 years ago

  Hi @ismcagdas Thanks for giving reference. but no solution is working for me.

  Save Cancel
• 

  0

  ismcagdas created 2 years ago

  Support Team

  Hi @sumitshah

  Could you share how do you create the query ? Is it handled in DatabaseHelper ?

  Thanks,

  Save Cancel
• 

  0

  sumitshah created 2 years ago

  Hi @ismcagdas We are generating query as commandText having "@p0" , "@p1" placeholder, commandType as Text, and passing SqlParameter as params Array. Yes, it is handled in DatabaseHelper.cs file. Please refer below code.

  public DbCommand CreateCommand(string commandText, CommandType commandType, params SqlParameter[] parameters) { var command = GetContext().Database.GetDbConnection().CreateCommand();

          command.CommandText = commandText;
          command.CommandType = commandType;
          command.Transaction = GetActiveTransaction();
          foreach (var parameter in parameters)
          {
              command.Parameters.Add(parameter); // from this line it is givinng us exception "The SqlParameterCollection                                                                                     //only accepts non-null SqlParameter type objects, not SqlParameter                                                                                     //objects"
          }
  
          return command;
      }
  

  Save Cancel
• 

  0

  ismcagdas created 2 years ago

  Support Team

  Hi @sumitshah

  Have you tried adding a default value if the parameter is null ? By the way, this problem doesn't seem related to AspNet Zero.

  Save Cancel