How to query database using LINQ to bring data from database based on array of months in ASP.Net MVC 5?

Question

I have a table like blow image:

enter image description here

How do I write a LINQ query to bring records of Jan, Feb, March from the table?

my query:

 var query = (from c in db.TheMonthlyDelivery  select c).AsQueryable();

I am new to LINQ please help me.

You didn't mentioned your attempted code initially, apart from that your query don't show any "efforts", your query is simply selecting the whole data, is that how you query your tables in database? — Rahul Singh
– Rahul Singh, Commented Dec 17, 2014 at 6:23

Rahul Singh · Accepted Answer · 2014-12-17 06:34:38Z

1

Try this:-

int[] months = { 1, 2, 3 };
var query=  db.TheMonthlyDelivery.Where(x => months.Contains(x.Date.Month));

answered Dec 17, 2014 at 6:34

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

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

1 Answer 1