linq to sql - Grouping and count with LinqToSQL -

-

मेरे पास एक कलाकार तालिका और एक स्टाइल टेबल है।

कलाकार तालिका: आईडी नाम स्टाइलिड

शैली तालिका आईडी का नाम

एक कलाकार की एक शैली आईडी है

मैं एक स्टाइल सारांश वापस करने की कोशिश कर रहा हूं जिसमें शैली आईडी, शैली का नाम और कलाकारों की संख्या शामिल है उस शैली।

मुझे निम्नलिखित कथन मिल गया है जो मुझे आईडी और कलाकारों की संख्या को प्राप्त करता है लेकिन मैं नहीं देख सकता कि शैली का नाम कैसे प्राप्त किया जाए। 

  डीबीसीटीएक्स में एसटीईएल कलाकार शामिल हैं। एसआईडी पर कलाकार कलाकार के बराबर हैं। कलाकार द्वारा स्टाइलआईड समूह कलाकार। स्टाइलआईड को किसी नए डीटीओ में टाइप करें। स्टाइलसमुरी {आईडी = ए। के, संख्याओएफ़आर्टिस्ट्स = ए.काउंट ()};

क्या एक गोल यात्रा के साथ यह संभव है?

आप कई मानों के आधार पर एक गुमनाम प्रकार के समूह का उपयोग कर सकते हैं: 

  डीबीसीटीपस्ट में एस से वापसी। एसटीआईएसटी में कलाकारों से जुड़ें। एसआईडी पर कलाकार कलाकार के बराबर होते हैं। स्टाइलआईड समूह कलाकार नए एसआईडी द्वारा , S.Name} एक चुनिंदा नए डीटीओ.StyleSummary {ID = a.Key.ID, नाम = a.Key.Name, numberOfArtists = a.Count ()} में;

Comments

Post a Comment

Popular posts from this blog

SQL/PHP: Table design question -

-
I have two tables, called a "cart" and what I call "items" That the cart be able to store a "item" and a list of quantities. That's why I have created another table "cart_items" which contains the ID of the template, the ID of the item and the quantity. Is this a good design, or should I add another area for the ID of "cart_itim"? Or is there a better way to do it all together? When I try to update my car, I am just running in trouble, my cart items do not update properly, what am I going to do all "cart_times" by car Is connected and then to re-add each "cart_item" and I can not help but it seems that there should be a better way This is a very good design. In the words ER (unit relationship) there are many relationships between objects and cart, through this I mean that an item can appear in many different trains and many different in a cart - Different items may be included In this context ...
Read more

NHibernate Passing Session to the Repository -

-
How do I go about passing a session for a repository class? We say that I have two projects 1) TestSite 2) Business Objects The Republican Business Objects Project is included in the project. The NHibernate session has been opened in the test site project. Now, I want to use the same session because the test site initiates the transaction on that session. Currently, I am using the following: var repository = New Customer Resor (_session); Of course, it looks ugly! I'm thinking in some way that a dependency injection frame can be tilted and I can be provided without entering the repository with the ejection object. In our WCF service, we actually use a unitofwork that wraps an operation and stores ISSN for that operation. . The repositories know how they are receiving a hint from the current unit of work under which they are running In case of testing we have a base test class, Those who are included in any test class, who touch the test database, we then control t...
Read more

c# - XMLDocument.Validate Error: System.InvalidOperationException : The XmlSchemaSet on the document is either null or has no schemas in it -

-
When I wanted to verify my in-memory xml schema, I found this strange error, did I do anything wrong? [Test] Public Zero Validation XML () {int errorCount = 0; On xmlString = "& lt ;? xml version = '1.0'> ?? response & gt; error code = '1' & gt; success & lt; / error & gt; & lt; / Reaction & gt; "; XmlDocument xmlDocument = New XmlDocument (); XmlDocument.LoadXml (xmlString); XmlDocument.Validate ((sender, e) = & gt; error code +); Assurance First (0, error code); } The exception was: failed: System.InvalidOperationException: XmlSchemaSet on the document is either empty or has a schema in it. Provide schema information before making a valid call System.Xml.XmlDocument.Validate (ValidationEventHandler validationEventHandler) You are trying to validate a schema describing XmlDocument xmlDocument .Schemas.Add (New XmlSchema ()); To verify it in front of an empty schema (as opposed to zero) and verificat...
Read more