创建数据库sqlit-netXamarin表单的代码有什么问题

Question

数据代码问题

如果你能帮助我解决问题，我在Xamarin表单上使用Sqlite net构建了一个学生信息应用程序
我需要添加信息并显示该信息但是Fname 有一个问题

ObservableCollection<Student> data0 = new ObservableCollection<Student>(
Student.Where(s => s.Fname.StartsWith(searchName)).ToList());

这是我的鳕鱼

namespace Aj.Service
{
public  class Database
{
private readonly SQLiteAsyncConnection data;
public  Database(string dbath)
{
data = new SQLiteAsyncConnection(dbath);
data.CreateTableAsync<Student>().Wait();
}
public async Task<List<Student>> GetStudents()
{
var student = await data.Table<Student>().ToListAsync();
if (student.Any())
{
await data.InsertAllAsync(objects: new Student[]
{
new Student{ID=1,Fname="حسان",Mname="صالح",Evaluation=5,Lname="خالد", },
new Student{ID=2,Fname="فلاح",Mname="سعيد",Evaluation=5,Lname="معيض", },
new Student{ID=3,Fname="ثابت",Mname="شافي",Evaluation=5,Lname="عايض", },
new Student{ID=4,Fname="مطر",Mname="مصلح",Evaluation=5,Lname="رغدان", }
});

}
return await data.Table<Student>().ToListAsync();
}


public  ObservableCollection<Student> GetStudentsByName(string searchName)
{
ObservableCollection<Student> data0 = new ObservableCollection<Student>(
Student.Where(s => s.Fname.StartsWith(searchName)).ToList());
return data0;
}



}
}

Answer 1

您在查询中使用类名Student

public  ObservableCollection<Student> GetStudentsByName(string searchName)
{
var students = GetStudents();
ObservableCollection<Student> data0 = new ObservableCollection<Student>(
students.Where(s => s.Fname.StartsWith(searchName)).ToList());
return data0;
}