Add Db.Null section for nullable parameters

[Tobias-Werner-Recom]

Type of issue

Missing information

Description

Add info about Db.Null to the parameter documentation for nullable parameters. The following code throws an exception System.InvalidOperationException: Value must be set..

var command = _db.CreateCommand();
command.CommandText = @"
INSERT INTO users (key, user)
VALUES ($key, $user);
";
command.Parameters.AddWithValue("$key", 1)
command.Parameters.AddWithValue("$user", null)
command.ExecuteNonQuery();

Instead of null one must set System.DBNull. Add this to the documentation.
Corrected code:

var command = _db.CreateCommand();
command.CommandText = @"
INSERT INTO users (key, user)
VALUES ($key, $user);
";
command.Parameters.AddWithValue("$key", 1)
command.Parameters.AddWithValue("$user", System.DBNull.Value)
command.ExecuteNonQuery();

Referenced Issue: dotnet/efcore#19775

Page URL

https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/parameters

Content source URL

https://github.com/dotnet/docs/blob/main/docs/standard/data/sqlite/parameters.md

Document Version Independent Id

3b84b19f-3d58-5a7d-90a7-0e35f6578fcf

Article author

@ajcvickers

Metadata

• ID: 0e9c919d-061c-c668-04d2-5f04cfabb587
• Service: dotnet-data