Geek asks and answers

Attach LINQ with list <> to select new

Hi, the first time I ask here, so I try to do it right

I have a problem with creating a shopping cart and im almost there, but always, but

what I want to have is something like this

List<HKurv> KurvInnhold = (List<HKurv>)Session["KurvInnhold"];
DataClasses1DataContext db = new DataClasses1DataContext();

if (Session["KurvInnhold"] != null)
        {
            var query = from a in db.Cabinets
                        from b in db.Commodities
                        from e in db.sArticleNumbers
                        from d in KurvInnhold

                        where
                        d.VareKjøpt.Contains(e.ArtNum) &&
                        a.ArticleNumberID == e.ID &&
                        a.ArticleNumberID == b.ArticleNumberID

                        select new
                        {
                            BestiltAntall = d.AntallValgt,
                            Price = b.Price,
                            ModelName = a.ModelName,
                        };

            Handlekurv1.DataSource = query;
            Handlekurv1.DataBind();
        }

But this does not allow the use of db and list <> in the same request

Solved! Modified Magnus Answer

            var kjopKollonne = from p in KurvInnhold
                               select p.VareKjøpt;

            var query1 = (from a in db.Cabinets
                         from b in db.Commodities
                         from e in db.sArticleNumbers

                         where
                         kjopKollonne.Contains(e.ArtNum) &&
                         a.ArticleNumberID == e.ID &&
                         a.ArticleNumberID == b.ArticleNumberID
                        select new
                         {
                              ArtNum = e.ArtNum,
                              Price = b.Price,
                              ModelName = a.ModelName,
                         }).ToList();

            var query2 = from a in query1
                         join b in KurvInnhold on a.ArtNum equals b.VareKjøpt
                         select new
                         {
                              BestiltAntall = b.AntallValgt,
                              Price = a.Price,
                              ModelName = a.ModelName,
                         };

            Handlekurv1.DataSource = query2;
            Handlekurv1.DataBind();
+3
source share
1 answer

Try the following:

var query1 = from a in db.Cabinets
  from b in db.Commodities
  from e in db.sArticleNumbers
  from d in KurvInnhold
  where
  KurvInnhold.Select(k => k.VareKjøpt).Contains(e.ArtNum) &&
  a.ArticleNumberID == e.ID &&
  a.ArticleNumberID == b.ArticleNumberID

 select new
  {
       ArtNum = e.ArtNum,
       Price = b.Price,
       ModelName = a.ModelName,
  }.ToList();

var query2 = 
  from a in query1
  join b in KurvInnhold on a.ArtNum equals b.VareKjøpt
  select new
  {
       BestiltAntall = b.AntallValgt,
       Price = a.Price,
       ModelName = a.ModelName,
  };

Handlekurv1.DataSource = query2;
Handlekurv1.DataBind();
+1
source

More articles:


All Articles