LINQ Syntax

In 的使用方式

var allowedTags = new[]{ "1", "2", "3" };
var _data = _db.SensorData.Where(q =>showTags.Contains(q.TagID))

Table Join

var query = (from s in context.Stock
             join cs in context.CodeStock on s.IdStock equals cs.IdStock
             where s.Date >= DateTime.Parse("02/12/2014) 
             select new 
             { 
                CodeStock = s.CodeStock, 
                Date = s.Date, 
             }).ToList();

Distinct

myList.GroupBy(i => i.id).Select(group => group.First())
//https://stackoverflow.com/questions/19406242/select-distinct-using-linq