c# - Create a Expression in LINQ -


मेरी LINQ क्वेरी नीचे कोड की तरह है। 

  var data2 = data.Where ( सी = & gt; स्ट्रिंग.फ़ॉर्मेट ("{0: MM / dd / yyyy}", सी। ऑर्डर डेट) == "07/04/1996");   
 मुझे नीचे अभिव्यक्ति में स्वरूपित कॉलम के लिए वर्डेट को कस्टमाइज़ करने की आवश्यकता है I मुझे परिभाषा के लिए अभिव्यक्ति लिखना और स्वरूप के आधार पर डेटा को फ़िल्टर करना होगा। कृपया नीचे कोड की जांच करें।  
  pred = अभिव्यक्ति। एक्वल (सदस्यप्रति, अभिव्यक्ति। कॉन्स्टेंट (मूल्य, प्रकार)); लैम्ब्डा = अभिव्यक्ति। लैम्ब्डा (विदग्ध, पैराएक्सप्रेस); स्रोत। कहां (पैरामी एक्सपेरशन, वर्डिकेट);   
 धन्यवाद।   
 
 
 यहाँ एक नमूना है जो  नया डेटा {OrderDate = "07/04/1996"}, नया डेटा {0}।  गतिशील रूप से।  
  स्थिर शून्य डायनेमिकव्वेरबिल्डर () {var datas = new data [ OrderDate = "07/04/1990"}, नया डेटा {ऑर्डर डेट = "07/04/2001"}, नया डेटा {ऑर्डर डेट = "2012/04/07"}}; IQueryable & LT; डाटा & gt; QueryableData = datas.AsQueryable & lt; डेटा & gt; (); Var प्रारूप कॉन्स्टेंट = अभिव्यक्ति। कॉन्स्टेंट ("{0: MM / dd / yyyy}", टाइपफ (स्ट्रिंग)); Var पैरामीटर = अभिव्यक्ति। पैरामीटर (टाइपफ (डेटा), "डेटाएआरजी"); Var गुण = अभिव्यक्ति। प्रॉपर्टी (पैरामीटर, "ऑर्डर डेट"); Var left = Expression.Call (संपत्ति, टाइपफ (स्ट्रिंग) .GetMethod ("प्रारूप", नया प्रकार [] {टाइपफ (स्ट्रिंग), टाइपफ (ऑब्जेक्ट)}), फ़ॉर्मेट कॉन्स्टेंट, प्रॉपर्टी; Var सही = अभिव्यक्ति। कॉन्स्टेंट ("07/04/2001", टाइपफ (स्ट्रिंग)); Var समान = अभिव्यक्ति। एक्वल (बाएं, दाएं); वां कहां है CallAxpression = Expression.Call (टाइपफ (Queryable), "कहां", नया प्रकार [] {queryableData.ElementType}, queryableData.Expression, Expression.Lambda & lt; Func & lt; डेटा, bool & gt; & gt; (बराबर, नया पैरामीटर एक्सेशन [] { पैरामीटर})); Var परिणाम = queryableData.Provider.CreateQuery & lt; डेटा & gt; (whereCallExpression); // ऑर्डरडेट के साथ ऑब्जेक्ट देता है = "07/04/2001"}

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more