static void PrintPostsTagsByTagId(string tagId) { var postsTags = Repository .Context .PostsTags .Where(pt => pt.TagId.Equals(tagId)); PrintHelper.SubTitle($"TagId: {tagId}"); foreach (var postTag in postsTags) { PrintHelper.Text($"PostId: {postTag.PostId}"); } PrintHelper.BlankLine(); }
static void Main(string[] args) { Repository.Initialize(); PrintHelper.Title("-Entity Framework Core 5 ToQueryString example -"); PrintHelper.SubTitle("Example using contains"); var queryString = Repository.Context .Posts .Where(p => p.Title.Contains("Post")) .ToQueryString(); PrintHelper.Text(queryString); PrintHelper.BlankLine(); PrintHelper.SubTitle("Example using EF.Functions.Like"); queryString = Repository.Context .Posts .Where(p => EF.Functions.Like(p.Title, "%Post%")) .ToQueryString(); PrintHelper.Text(queryString); }