var query = ( from v in dbContext.UnitFeatureValue join u in dbContext.Unit on v.FK_Unit_ID equals u.ID join t in dbContext.FeatureTitle on v.FK_FeatureTitle_ID equals t.ID where v.FK_Unit_ID == 15 && t.canMoreSelect == 1 select new { v.FK_Unit_ID, u.unitNumber, u.unitTitle, t.featureTitleName, }).Distinct(); 3 solved Convert this sql command to c# linq
Introduction This article will provide a step-by-step guide on how to convert a SQL command to a C# LINQ query. LINQ (Language Integrated Query) is a powerful query language that allows developers to write queries in a more concise and expressive way. It is a great way to simplify complex SQL queries and make them … Read more
You can use Linq only: bool hasAllItems = UserList.All(s => SystemList.Any(mo => mo.Id == s)); 0 solved Check if a list of objects contains another list (only have a property) in C# Linq
Firstly this code is really starting to need a ViewModel or some other construct that would enable you to decouple your business logic from your UI. Having said that, the quick and dirty answer to get you going, would be to implement an interim linq query and then build your results from that // From … Read more
What you’re ordering by here is the distance between the pivot (the birthdate) and each date. Something like this: var sorted = data.OrderBy(date => (birthdate – date).TotalDays); will sort by distance, but put all the after dates first, because the TotalDays will be negative, then the before dates. To avoid that, we need to implement … Read more
None of the other answers leverage the lookup-speed of the dictionary: var matches = allBills .Where(dict => dict.billList.ContainsKey(“User”)) .Where(dict => dict.billList[“User”] == “Nick”); 4 solved Linq in dictionary collection [closed]
Well, what we don’t know is your model structure or what LINQ provider you’re using. However, in general, with a well-structured domain model, you’d simply do this: db.Posts.Where(p => p.Comments.Count() > x) Given an integer variable x, this should evaluate to the collection of Post objects in which there are more than x comments. solved … Read more
Here’s a working sample: http://dotnetfiddle.net/LNksSW The reason for the error you’re getting is that you’re missing Imports System.Linq at the top of your file. Dim dt as DataTable = new DataTable dt.Columns.Add(“col1”) dt.Rows.Add(“1000000”) dt.Rows.Add(“0010000”) dt.Rows.Add(“0100000”) Dim result = dt _ .AsEnumerable() _ .Select(Function(r) r.Field(Of String)(0)) _ .Select(Function(s) string.Join(“”, s.Select(Function(x, i) _ If(x = “0”, “0”, … Read more
I give it a try, though a lot of questions are open (what type of list, what a column, …). In short: you can use String.Insert to insert text at a specified postition. Assuming you have a List<Foo>, the class Foo has a string property Value (your column). If it’s Length exceeds 100 the line … Read more
Try code like this using System.Collections.ObjectModel; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Text.RegularExpressions; namespace ConsoleApplication57 { class Program { static void Main(string[] args) { int employeeId = 113; List<E_JOURNAL> employee = E_JOURNAL.journals.Where(x => x.JOURNALID == employeeId).ToList(); var results = (from j in employee join s in E_ABSENCE.absenses on j.JOURNALID equals s.JOURNALID orderby … Read more
Ugh, be prepared for an accident that makes a mess of your data with this “associated by position” idea I wouldn’t use LINQ for this either var l = new List<string>(); string prev = null; foreach(DataRow r in dt.Rows){ var s = (string)r[“Column1”]; var t = (string)r[“Column2”]; if(s != prev){ l.Add(s); prev = s; } … Read more
Poor man’s async/await await Task.Factory.StartNew(() => PopulateList()); EDIT For those who want to see the usage of it How can i send email one after one in a row? and its follow-up question How do i make that it will send the email only once? 3 solved How to write async linq
Got it. Thanks for the help guys. var fullList= from session in mSessions join testRun in mTestRuns on session.Id equals testRun.SessionId where session.Value.Username.Team == “whatever” select new { testRun.Anything }; int count = fullList.Count(); solved Count linq statement with joins
You could try collecting every db entry that matches your criteria first public static IEnumerable<string> GetFiles(List<string> srcFiles) { var filePaths = new List<string>(); using (var db = new ContentMgmtContext()) { foreach (var fileInfo in srcFiles.Select(file => new FileInfo(file))) { var matches = db.Files.Where(o => o.FileName.ToLower() == fileInfo.Name.ToLower() || o.FileSize == fileInfo.Length.ToString()) if (matches.Count() > 0) … Read more
from s in db.tblMaster let t= from u in db.tblUHTs where u.UId=’F7ECFB41-177F-4408-B856-A4F669FAA714′ select u.HTId where t.Contains(s.HTId) select new {s.HTId, s.HTN} 1 solved linq query analogous to sql Not In, In clause