score:0
Accepted answer
var alerts = await alerttable.where(n=> n.startdate >= fromdate && n.startdate <= todate).tolistasync();
score:0
var alerts = await alerttable.where(n=>n.accountid==client.currentuser.userid && n.startdate.date == date.date).tolistasync();
Source: stackoverflow.com
Related Query
- LINQ Query against Azure table service fails
- Running a Contains operator in Azure Table Service linq query
- Error creating LINQ query against Azure Table Storage
- RavenDB LINQ query against index fails
- Azure table Storage - Table service Query to retrieve and return 10 entities till last entity
- want to get data from specific column of azure mobile service table using linq
- LINQ to SQL Query Against Bridge Table
- How to effectively do dynamic query using LINQ against a Azure Cosmos Document DB SQL API?
- Creating query filters for Azure Table Service from base class
- C# dynamic table creation : display table data in aspx page using linq query in a wcf service
- Casting to a derived type in a LINQ to Entities query with Table Per Hierarchy inheritance
- How do I query an Azure storage table with Linq?
- How do I write a linq query against a ListCollectionView?
- Linq query join one table row to another table multiple row
- Check LINQ query against SQL Server database
- Simple Linq query has duplicated join against same table?
- linq query to join two tables and get the count from one table values from the other
- linq join query get single record from second table
- LINQ Query to check for a predicate in all columns in a table
- Which LINQ query to select rows from 1 table that are not in another table
- LINQ to Entities three table join query
- Linq query to join against list in a struct
- How to create a dynamic 'contains or LIKE' Expression to be used with Linq against OData service
- linq query fails only on Contains "Object reference not set to an instance of an object"
- Windows Azure Table Storage LINQ Operators
- LINQ query fails when counting an int
- How to dynamic add filters to a LINQ query against an Odata Source in C#
- Azure Table Storage Query in .NET With Property Names Unknown at Design Time
- Exception in a CRM LINQ query with joins. Attribute in second table doesn't exist
- How to return both parent and child using LINQ against 1 table
More Query from same tag
- Linq select one of list where one of its child objects properties matches a value
- Entity-framework / Linq: How to left join while grouping into custom select?
- Datatable null to empty string
- Filter on a collection using a List containing arguments
- Linq Group by Row into Column
- SQL to LINQ with left join subqueries
- LINQ One to Many, 3 levels Deep Question
- Linq Query syntax System.Xml.Linq.XElement
- How to order a list by property and group the elements in HTML Razor?
- Is there a way to find the max of a linq count function?
- CS1061 'IEnumerable<<anonymous type: x>>' does not contain a definition for dump
- How would I use an anonymous result type for an expression delegate for LINQ to SQL?
- Get latest previous year if possible
- .Contains() on 2 properties in EF Code First
- How can I directly execute SQL queries in linq
- Get Value and Count of that value using LINQ or lambda expression
- Linq Query Message: Specified cast is not valid
- How to convert whole Bson document to a string in dotnet
- Linq GroupBy into new object
- How to convert Sum over partition from T-SQL
- LINQ ordering by highest value per unique value in a certain column
- How to flat a IEnumerable by 2 Values?
- How to parse an unstructured csv file
- Store data within alphabetically ordered letters (A - D, E - H, I - L, etc) using Dictionary
- How to join ListQueryable table and return toList();
- MemberExpression as object of its type
- Fill in property in list from another list by joining them
- Can you use LINQ to do a process such as converting part of a list and assigning to another?
- What is the best way to databind Web Form controls to linq objects?
- Filter query by multiple parameters from the list of objects