实体框架核心PostgreSQL JSON查询 [英] Entity Framework Core PostgreSQL json query
本文介绍了实体框架核心PostgreSQL JSON查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
总是返回空结果
var collection = await _context.Settings
.Select(s => new
{
s.SettingId,
s.SettingParentId,
SettingValue = s.SettingValue.GetProperty(lang)
})
.Where(s => EF.Functions.JsonExists(s.SettingValue, lang))
.ToListAsync();
我尝试从json仅返回键,但总是返回空,当删除 select时效果很好,但我只需一个键
I try return only key from json but always return empty, when remove "select" works fine but i need only one key
这是模型
public class Setting
{
public string SettingId { get; set; }
public string SettingParentId { get; set; }
public JsonElement SettingValue { get; set; }
}
推荐答案
我认为你是寻找以下内容:
I think you're looking for something like the following:
class Program
{
static async Task Main(string[] args)
{
await using var ctx = new BlogContext();
await ctx.Database.EnsureDeletedAsync();
await ctx.Database.EnsureCreatedAsync();
var lang = "es";
var collection = await ctx.Settings
.Where(s => EF.Functions.JsonExists(s.SettingValue, lang))
.Select(s => new
{
s.SettingId,
s.SettingParentId,
SettingValue = s.SettingValue.GetProperty(lang).GetString()
})
.ToListAsync();
foreach (var i in collection)
{
Console.WriteLine($"{i.SettingId}: {i.SettingValue}");
}
}
}
public class BlogContext : DbContext
{
public DbSet<Setting> Settings { get; set; }
static ILoggerFactory ContextLoggerFactory
=> LoggerFactory.Create(b => b.AddConsole().AddFilter("", LogLevel.Information));
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder
.UseNpgsql(@"Host=localhost;Username=test;Password=test")
.EnableSensitiveDataLogging()
.UseLoggerFactory(ContextLoggerFactory);
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Setting>().HasData(new Setting
{
SettingId = "1",
SettingValue = JsonDocument.Parse(@"{ ""es"" : ""valor""}").RootElement
});
}
}
public class Setting
{
public string SettingId { get; set; }
public string SettingParentId { get; set; }
public JsonElement SettingValue { get; set; }
}
这篇关于实体框架核心PostgreSQL JSON查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文