LINQ

Thank you very much for quick answer!

I think you're trying to resolve your issue by complicating it too much... ;) Note, that Count can accept condition to get interesting data (which works like Where). See: [Enumerable.Count Method (System.Linq) | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/api/system.linq.enumerable.count?view=netcore-3.1#System\_Linq\_Enumerable\_Count\_\_1\_System\_Collections\_Generic\_IEnumerable\_\_\_0\_\_) So... var finalTotal = from t1 in _context.Apiapplicant join t2 in _context.ApiApplicantHistory on t1.Id equals t2.ApiApplicantId join t3 in _context.EntityType on t2.LastReqStatus equals t3.Id where t1.IsDeleted == false && t2.Date != null && t1.ApiRequestNo != null group t1 by new { lastReq = t2.LastReqStatus, Year = t2.Date.Substring(0, 4), Month = t2.Date.Substring(5, 2) } into g select new { Year = g.Key.Year, Month = g.Key.Month, lastReq = g.Key.lastReq, Granted = g.Count(x=>x.t2.Name == "granted"), Other = g.Count(x=>x.t2.Name != "granted"), TotalCount = g.Count() };

var dept = departments.OrderByDescending( d => d.DepartmentName.length ).First(); It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food

The error is with in the query string. Between keyword does not work well with string datatype.

To Insert new record: bool InsertNewProduct(Product p) { myDataContext dt= new myDataContext(); dt.Products.InsertOnSubmit(p); dt.SubmitCHanges(); return true; } To Insert new record: bool DeleteProduct(Product p) { myDataContext dt= new myDataContext(); dt.Products.DeleteOnSubmit(p); dt.SubmitCHanges(); return true }

You simply add first to the end of the Select logic listViewModel.EmailRecipients.AddRange( from r join p on r.PId equals p.PId join gp on p.PId equals gp.PId join hp on gp.HPId equals hp.HPId orderby p.LastName, p.FirstName select(new EmailRecipientViewModel { PId = p.PId, FirstName = p.FirstName, LastName = p.LastName, Email = "", }) ).First();

Try the following approach: public Product GetLastProduct(DataContext dt) { return dt.Products.Last(); } this code assumes two things: 1. your database has a Product table 2. You have created LINQ to SQL and you have dragged and Dropped the Product table on to the DataContext named dt

[LINQ to SQL | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/) "(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal

You need to use your debugger to see what is added to your List and why it includes the parent object.

Good one Richard.

To avoid null values in your linq result, then you need to write the query like as shown below. var q = from a1 in dt\_Jobs.AsEnumerable() where !string.IsNullOrEmpty(a1.Field("City")) orderby a1.Field("City") select a1.Field("City"); var lstCity = q.Distinct().ToList(); cboCity.DataSource = lstCity; To know how to use linq with dataset, check following article it will help you. LINQ to Dataset with Example[^]

What do you mean by it fail? It should have to give you issue/error but you did not mentioned that.

Considering your code does not contain any LINQ that is an interesting assumption.

Sorry, but your query looks ugly and probably is inefficient... First of all, the query you provided is "asking" your database (ARN_1 table) 3 times! You have to re-think your sql statement. There must be shortest (easiest) way! Secondly, you did not provide a linq version and did not provide why you had no luck till this moment. Please, edit your question and provide more details. A piece of input data and expected output might be helpful to understand your issue.

If you would like to implement CompareTo() method, check this: [IComparable.CompareTo Method (Object) (System)](https://msdn.microsoft.com/en-us/library/system.icomparable.compareto(v=vs.110).aspx). GreaterThan() and LessThan() methods won't work on strings. Why? It's simple. String is not numeric value! To be able to compare lowValueString and highValueString with the set of numbers, you need to convert string values into proper data type. Convertion should be made before you data into Between method.

Below is my answer despite it is too late: var lines = File.ReadLines(filepath).ToArray(); ( from line in lines where !string.IsNullOrEmpty(line) select line.Split(',')[0] ).ToList() .ForEach(item => this.cboSiteLocation.Items.Add(item.Trim());

:thumbsup: Super! Thanks!