Search code examples
c#resharpercollection-initializer

use collection initializer with insert statement


I have the following method:

public bool InsertUsername(string username)
{
    string SQL = "Insert into [Users](Username, InsertDateTime) Values(@Username, datetime('now'));";
    List<SQLiteParameter> pars = new List<SQLiteParameter>();
    pars.Add(new SQLiteParameter("@Username", username));
    return SQLiteUsernameDatabase.ExecuteNonQuery(SQL, pars);
}

ReSharper is telling me to use the collection initializer for the pars List.

Question: How do I add the SQLiteParameter to the collection initializer?


Solution

  • Nevermind, found the solution already:

    public bool InsertUsername(string username)
    {
        string SQL = "Insert into [Users](Username, InsertDateTime) Values(@Username, datetime('now'));";
        var pars = new List<SQLiteParameter> {new SQLiteParameter("@Username", username)};
        return SQLiteUsernameDatabase.ExecuteNonQuery(SQL, pars);
    }