Comments (7)
I don't know if it's possible to do in Select but you could do:
var test1 = _context.Blogs.AsQueryable().Where("ModifyDate != null")
.Select("ModifyDate.Value.ToString(\"yyyy-MM-dd\")");
from system.linq.dynamic.core.
jotab123, thanks for your reply, but this is not my purpose, in your way, just find the not null value, but actually, I need to find all values, if it's null then will show empty or other thing, otherwise will format it and display
from system.linq.dynamic.core.
Why not just execute the ToString method on a list instead of the queryable ? In that case you don't have issues with Linq-SQL.
from system.linq.dynamic.core.
sorry, can you give me a sample how to do that? thanks!
from system.linq.dynamic.core.
var list = _context.Blogs.Select("it.ModifyDate").ToDynamicList<DateTime>();
var result = list.Select(x => x ?? x.Value)).ToString("yyyy-MM-dd")).ToList();
from system.linq.dynamic.core.
but for my case, I need to generate a full dynamic query for get the result, and I don't want to convert to list at first, because I have a lot of data in the table, if it to list first then will get all data and the performance will be bad, that why I need to use IQueryable .
and I know if I convert to list object then I can easy to use HasValue method in the query.
from system.linq.dynamic.core.
Did you already try the ? operator
?
Like
var q = _context.Blogs.AsQueryable();
var x = q.Select("it.ModifyDate != null ? [[[format to string]]] : null");
from system.linq.dynamic.core.
Related Issues (20)
- Value typed property from subquery are casted as `object` HOT 4
- SelectMany collectionSelectorArgs not allowing context.Set<>() HOT 1
- C# Entity Framework Core - OrderBy and Where don't work with `[ComplexType]` HOT 6
- try to call function inside select HOT 3
- Basic performance consideration question HOT 1
- try to parse lambda with function inside .
- Performance Issue with EF Core 8.0 and Microsoft.EntityFrameworkCore.DynamicLinq Package HOT 8
- Question About Parameters HOT 4
- Parser interpreting the two consecutive escape sequences \"\" as a single escape sequence HOT 11
- query generated with dynamic linq not parse parameter linq as parameter sql !!! HOT 1
- Add JSON support HOT 9
- .NET 8 (and possible all non-NETSTANDARD and higher versions) attempt to load EF 6 types HOT 14
- Add ParsingConfig option to support single quotes in place of double quotes
- Failure in ParseArgumentList when using lambda filter on list of dictionaries HOT 1
- DynamicExpressionParser.ParseLambda regressions in v1.3.10
- Error with 'Equals' together with other parameters HOT 4
- ExpressionParser finds Types from IEnumerable instead of IQueryable (breaks Code) (worked in 1.3.9) HOT 1
- Updating to 1.3.13 - No property or field 'XXXXX' exists in type 'Char'
- Issue with Where() method when filtering multiple string properties while using ToLower() HOT 1
- >= 1.3.3 Slow First Dynamic Select HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from system.linq.dynamic.core.