How to remove warning EF1000?

Question

SQLite

The code:

public bool SetNewDate(string date, string newDate)
        {
            string sql = string.Format(@"
UPDATE EventSchedule
SET Date = '{0}'
WHERE Date = '{1}'", newDate, date);

            var rows = _context.Database.ExecuteSqlCommand(sql);

            return rows > 0;
        }

A warning:

warning EF1000: The SQL expression passed to 'ExecuteSqlCommand' embeds data that will not be parameterized.

Answer 1

Do not use string.Format for parameterization.
Use additional parameters from ExecuteSqlCommand or ExecuteSqlInterpolated instead.
https://docs.microsoft.com/en-us/ef/core/querying/...