C# Linq query with where clause query containing a dynamic variable

Question

I have a entity object in c#. It queries a database table called FBApi. The table stores an integer year and integer month. I have function that needs to return all records greater than the passed in parameters.

public query(int myYear, int myMonth){
   var context = new MCSSUtility.Entities();
   return context.FBApis.Where(p => p.month == month && p.year == year);
}

I was thinking of converting the integers to a DateTime object, but i am not sure how to dynamically convert the where clause to Datetime variable?

public query(int myYear, int myMonth){
   DateTime my = new DateTime(myYear,myMonth,1);
   var context = new MCSSUtility.Entities();
   return context.FBApis.Where(p => new DateTime(p.year,p.month,1) >= my);
}

what do you want to return? You have to include the retrun type of the method (datetime or bool?). — Mitja Bonca
– Mitja Bonca, Commented Sep 4, 2012 at 17:28
Its just a quick example I created. Return isn't important. Thanks though. — user251291
– user251291, Commented Sep 4, 2012 at 17:41

petro.sidlovskyy · Accepted Answer · 2012-09-04 17:38:27Z

3

Please try this one:

            public query(int myYear, int myMonth){
               DateTime my = new DateTime(myYear,myMonth,1);
               var context = new MCSSUtility.Entities();
               return context.FBApis.Where(p => EntityFunctions.CreateDateTime(p.year, p.month, 1, 0, 0, 0)  >= my);
            }

edited Sep 4, 2012 at 17:38

answered Sep 4, 2012 at 17:30

petro.sidlovskyy

5,1032 gold badges27 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BlackjacketMack · Accepted Answer · 2012-09-04 17:32:15Z

0

Try first selecting an anonymous object with two properties: your FBApi object and your constructed datetime:

return context.FBApis
.Select(s=>new{MyFBAPIObject=s,MyDateTime=newDateTime(s.Year,s.Month,1)})
.Where(w=>w.MyDateTime>=my)
.Select(s2=>s2.MyFBAPIObject);

answered Sep 4, 2012 at 17:32

BlackjacketMack

5,7321 gold badge33 silver badges33 bronze badges

Collectives™ on Stack Overflow

C# Linq query with where clause query containing a dynamic variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related