如何以 Sqlite Xamarin 形式连接两个表值? [英] How to join two table values in Sqlite Xamarin form?

问题描述

我在我的 Xamarin 中从 C# 创建了两个模型 Outlet_model 和 TbTrdDocModel.我可以分别访问每个模型的值，但现在我想在 SQLite 中加入两个表.有人知道如何加入这两个模型来访问列表视图中的数据吗?提前致谢.

I have created two models Outlet_model and TbTrdDocModel in my Xamarin from C#. I can access the values from each model separately but now I want to join both tables in SQLite. Do anybody know how to join these two model to access the data in the listview? Thanks in Advance.

推荐答案

试试这个

public class MusicItems
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    public String Name { get; set; }
    public String Tension { get; set; }
    public String Category { get; set; }
    public String Subcategory { get; set; }
    public int ResId { get; set; }
    public int LoopStart { get; set; }
}
public class Playlist
{
    public String Name { get; set; }
    public int ResId { get; set; }
    public int LoopStart { get; set; }
}
public class Themes
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    public String ThemeName { get; set; }
    public String ThemeDesc { get; set; }
    public int ThemeImg { get; set; }
    public String ThemeCategory { get; set; }
    public String ThemeSubcategory { get; set; }
}
public class MusicInThemes
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    public int ResId { get; set; }
    public int ThemeId { get; set; }
}

查询:

return database.Table<MusicItems>() 
                    .Join(database.Table<MusicInThemes>().Where(t => t.ThemeId == ThemeID)
                        ,m =>m.ResId
                        ,t => t.ResId
                        ,(m,t) => new {mym = m, myt = t })
                    .Select(a => new Playlist
                        {
                            Name = a.mym.Name,
                            ResId = a.mym.ResId,
                            LoopStart = 0
                        })  
                    .ToList();

这篇关于如何以 Sqlite Xamarin 形式连接两个表值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！