此方法检索整个数据。 我正在尝试将此方法切换为使用字典的方法,但效果不佳。 INSERT,UPDATE和DELETE已完成,但是SELECT遇到了问题。
我想转换为如下链接源所示的my方法。 https://gist.github.com/thorsman99/e788dd9cce36c26edd9076c9dac288dd
public static List<TestModel> GetList(string id,string subject,string UseYN,string createDate1,string createDate2)
{
using(SQLiteConnection connection = new SQLiteConnection(_connection))
{
connection.Open();
using(SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = @"SELECT ID,Subject,CreateDate,UpdateDate FROM Test";
command.Parameters.Add(new SQLiteParameter(@"ID",DbType.String) { Value = id });
command.Parameters.Add(new SQLiteParameter(@"Subject",DbType.String) { Value = subject });
command.Parameters.Add(new SQLiteParameter(@"CreateDate1",DbType.String) { Value = createDate1 });
command.Parameters.Add(new SQLiteParameter(@"CreateDate2",DbType.String) { Value = createDate2 });
SQLiteDataReader reader = command.ExecuteReader();
List<TestModel> list = new List<TestModel>();
while(reader.Read())
{
TestModel item = new TestModel();
item.ID = reader["ID" ].ToString();
item.Subject = reader["Subject" ].ToString();
item.CreateDate = Convert.ToDateTime(reader["CreateDate"]);
item.UpdateDate = Convert.ToDateTime(reader["UpdateDate"]);
list.Add(item);
}
return list;
}
}
}