c# - Subsonic 3.0 and "Link" tables -

-

मेरे पास निम्न सेट-अप हैं।

BlogPosts BlogToCategory श्रेणी

एक ब्लॉग पोस्ट में कई श्रेणी हो सकते हैं और एक श्रेणी कई ब्लॉग पोस्ट में हो सकती है (इसलिए मध्यवर्ती तालिका।

मैं एक श्रेणी में सभी ब्लॉग पोस्ट्स की सूची कैसे प्राप्त करूं।

मैंने इसे करने की कोशिश की है लेकिन इसे सही नहीं लगता (मुझे एक IQueryable -> IEnumerable डाली त्रुटि मिलती है) 

  सार्वजनिक IEnumerable & lt; BlogPost & gt; FetchAllBlogs (int? CatId) {श्रेणी से c पर लौटें.सभी () जहां c.CategoryID == कैटआईडी का चयन करें C.BlogPost;}

ठीक है नीचे दिए गए मैंने कोशिश की है। 

  blogToCategories में से subtext_link.All () में शामिल हों subtext_content में blogPosts BlogToCategories.BlogId पर सभी () blog.posts.BlogId के बराबर है, जहां blogToCategories.CategoryID == कैट ऑर्डर से (blogPosts.DateAdded) ब्लॉगिंग पोस्टिंग अवरोही;

अब यह विचित्र है लगता है कि इसमें शामिल होने के रूप में गलत है जब भी लिंक तालिका में कुछ डेटा होता है (टैबलेट लिंक ब्लॉग पर श्रेणी) यह सभी ब्लॉग को रिटर्न देता है

इसके बाद भी नीचे की कोशिश की।

<पूर्व> ब्लॉग लिस्ट = नया ट्रांसफोर्मडीबी () चुनें। से & lt; subtext_Content & gt; ()। इनरजॉन & lt; subtext_link & gt; (subtext_linksTable.BlogIdColumn, subtext_ContentTable.BlogIdColumn )। जहां (subtext_LinksTable.CategoryIDColumn)। आईएस एक्वलटो (कैटआईडी) .ExecuteTypedList & lt; subtext_Content & gt; (); [Subtext_links]। [लिंक्सआईडी], [डीबीओ]। [Subtext_links]। [शीर्षक], [डीबीओ]। [सबटेक्स्ट_लिंक्स] [यूआरएल], [डीबीओ]। [एसटीएस], [डीबीओ]। [सबटेक्स्ट_लिंक्स]। [ब्लॉगइड], [डीबीओ]। [पोस्टिड], [डीबीओ]। [न्यूवंडो], [डीबीओ]। [सबटेक्स्ट_लिंक्स]। [रिले], \ आर \ n [डीबीओ] [सबटेक्स्ट_सेंट]। [आईडी], [डीबीओ]। [शीर्षक], [डीबीओ]। [सबटेक्स्ट-कंटेंट]। [तिथिप्रविष्ट], [डीबीओ]। [सबटेक्स्ट-कंटेंट]। [पोस्ट टाइप], [डीबीओ]। [Subtext_content]। [लेखक], [डीबीओ]। [ईमेल], [डीबीओ]। [सबटेक्स्ट] सामग्री। [ब्लॉगआईडी], [डीबीओ]। [सबटेक्स्ट कंटेंट]। [विवरण], [डीबीओ]। [Subtext_content ] [डाक अपडेट], [डीबीओ]। [पाठ], [डीबीओ]। [सबटेक्स्ट_सेंटेंट]। [फीडबैककाउंट], [डीबीओ]। [सबटेक्स्ट-कंटेंट]। [पोस्टकॉन्फिग], [डीबीओ]। [सबटेक्स्ट-कंटेंट]। [प्रविष्टिनाम], [डीबीओ]। [Subtext_content]। [दिनांकसमानित] \ r \ n से [डीबीओ]। [Subtext_links] \ r \ n इननर जॉइन [डीबीओ]। [Subtext_Co [Subtext_links]। [Subtext_links]। [BlogId] = [dbo]। [Subtext_content]। [ब्लॉगआईडी] \ r \ n जहां [डीबीओ]। [Subtext_links]। [श्रेणीआईडी] = @ 0 "

आपको BlotToCategory और BlogPost तालिकाओं में शामिल होने की आवश्यकता है: 

  सार्वजनिक IEnumerable & LT; ब्लॉगपोस्ट & gt; ब्लॉग के लिए ब्लॉग ब्लॉग्स (इन्ट। कैटआईडी) {ब्लॉग ब्लॉग श्रेणियों में से ब्लॉगटाओकेन्टेन्ट में वापसी। सभी () ब्लॉग में शामिल हों ब्लॉगपोस्ट में ब्लॉग। ब्लॉग पर। सभी () ब्लॉग पर ब्लॉग। श्रेणियां। ब्लॉग आईडी जहां ब्लॉगटोगेशंस। }

Comments

Post a Comment

Popular posts from this blog

objective c - iPhone and it's wireless area -

-
Is this a way to find other iPhones in the category of wireless areas? So I give an example. I'm staying at the airport somewhere I have an iPhone too. I and the other iPhone owners are playing the same game. Is there any way to warn me and the other player that we are close to each other? Does this work even if we are not on the same wireless network, or there is no wireless? And if there is any way to do this, can you give me some starting point? Like a link where I can learn something like this or maybe this is probably the name of this process, because I do not know how to search about this topic in Google. Thanks in advance! Can be completed with peer-to-peer discovery and connectivity you are describing Game Kit Framework Originally I thought it works only through Bluetooth, but after watching it immediately, it seems that WiFi is also supported. Hope it helps!
Read more

unix - Listing all shared memory segments used by a process on AIX5.3+ -

-
I would like to find all the shared memory segments used by a given process I am particularly interested in detecting shmid That's why I can use it in call (shmctl). On Solaris I will just read / proc / $ PID / map to find that information (field pr_shmid) The content of that file is defined by struct prmap_t in the sys / procfs format. Ax also has a / proc / $ PID / map file. Any project is a primate, but unfortunately it has been projected in pr_shmid field. Any ideas how can I get it on AIX5.3 +? I do not particularly know about AX, but I think that ipcs command is quite standard where SysV IPC is supported, so I want to get the ipcs -m command to give the appropriate code; If you can not find a better method, then there may be an option to parse its output.
Read more

tsql - Correct sql/hql query (aggregate in where clause) -

-
I want to query the query as below but the question is wrong but describes my intentions. select name, date time, data from record, date time = maximum (date time) Update: OK The description of the query intentions is not very good. My bad I want to select the latest record for each person. i like Mickey's answer and quosnoye (and upyoyed miki), but if your needs are similar to me , You should keep in mind some limitations. First and foremost, this works only when you are looking for the latest record or latest record for the same name. If you want the latest record for each person in a set (a record for each person but the latest record for each), then the above solutions are small. Second, and less importantly, if you work with a large dataset, then it can be slow for a long time. So, what's around the work? Whatever I do is to add a small field to mark the "latest" in the table. Then, when I store a record (which is done in the stored procedu...
Read more