Can you do an inner select with Subsonic?

This is my sql query: subsonic version No Linq (.net 2.0)

select ( select Title from MenuTranslation mnu2 where mnu2.languageid = 1 and mnu2.menuelementid = menutranslation.menuelementid )as BaseTitle, * from menutranslation inner join menuelement on = menutranslation.menuelementid where menuelementid in (select id from menuelement where parentid = 4) and languageid = 2


Not at this time - however you can run IN queries with a SELECT - not subqueries however.

You would need to use the inlineQuery class where you generate the sql yourself to accomplish what you are going after

Category:c# Time:2009-08-28 Views:0

Related post

  • TransactionScope, Selects using Subsonic 2009-08-25

    I have an Invoice table (and a SubSonic 'Invoice' ActiveRecord() with an InvoiceNumebr column that needs to have unique numbers. I am trying to GetTheNextAvailableNumber() inside of a TransactionScope using block. This works. What I'm not sure of is,

  • How Do I Write a SubSonic Select Statement that Sums Three Columns? 2009-07-25

    I have to SUM 3 Columns and return the value in my result. What is the proper way to write this? SubSonic.SqlQuery qs =new SubSonic.Select() .From(Table.ViewAllratingsGlo.Schema.TableName); SubSonic.Aggregate ag = SubSonic.Aggregate.Sum(("Column1+Col

  • Perform single selection with where 2009-05-21

    I'd like to achieve the following SQL statement with subsonic 2.2 SELECT Product.* FROM Product WHERE Product.OurPrice <> Product.RetailPrice The Subsonic select query I've started with: SubSonic.SqlQuery select = new SubSonic.Select() .From

  • SubSonic "Or" and "AND" 2009-08-21

    How to make this select in SubSonic using SqlQuery ? SELECT * FROM [dbo].[Tablexxx] Join Tableyyy on Tablexxx.fieldZZZ = Tableyyy.fieldZZZ WHERE Tablexxx.fieldxxx = 1 AND (Tablexxx.fieldyyy = 'S' or Tablexxx.fieldyyy = 'T') Thanks any help. Valmir --

  • Subsonic query: Problem with the produced query 2009-11-16

    I'm having a problem with subsonic quey. The deal is, I have a View and I want to query it's data to produce something like the following SQL statment: select * from myView where (col1 like '%a%' or col2 like '%a%' or col3 like '%a%') and col4 = 1 an

  • WebWorks App not working at all but works in Ripple and Chrome and in the BB Browser 2012-01-19

    I have a simple BlackBerry app i'm working on that uses JSONP and Zepto.js. Most of the code is written quickly, I haven't made use of Zepto as I should have and will but need to just test it for now and I believe its all my code is valid so far (new

  • Calling an SQL function from a Subsonic.Select 2009-03-30

    I asked the following question on the subsonic forum, but only seemed to get one response, so I thought I'd post up here as well to see if anyone could shed some more light on the problem... I wish to create the following SQL statement through SubSon

  • SubSonic - Specifying DataProvider in a Select() function 2009-04-14

    I specify the dataprovider in a subsonic Select as in the following example: SubSonic.Select(Databases.BLLDB).From(Of Country)().ExecuteTypedList(Of Country)() yet I get the error: Invalid column name 'BLLDB' (it seems to be treating the dataprovider

  • Rename fields in SubSonic select statement 2009-05-07

    Is there a way to rename fields when executing a select statement in SubSonic? I am using the ExecuteTypedList<MyClass> method to fill my List<MyClass> object but the properties of MyClass are not all the same as the column names from the

  • How to using select with multi table in SubSonic query? 2009-05-14

    I am new with SubSonic and have a problem with query. This is my query string string sql = "SELECT *" + " FROM tbl_exrates, tbl_currency" + " WHERE date = " + d; " AND tbl_exrates.currency = tbl_currency.cid" + " AND (cash > 0 OR transfer > 0 O

  • SubSonic Inner join Select problem 2009-05-27

    I have 3 tables and need to select some recoreds, In 2 table of them I have fileds with same name , and when I try to use Where Expression on these filed I got error message : If I use TABLENAMe.Columns.COLNAME this error message shows : Ambiguous co

  • Subsonic How to select between date 2009-06-15

    Could anyone tell me how to do the select function in SubSonic project to query all customer who will have birthday in next two week from today. Table Customer Name Thomas DOB 19/09/1981 Thank you --------------Solutions------------- If you're only u

  • Column with same name in multiple tables causing problem in SubSonic Select 2009-06-30

    there are other question (at least 2 I've seen them) similar to this but I'm not able to solve this using them. Now the problem: I've 3 table from which I need to select 4 columns only. I'm using InnerJoin and it is working perfectly. Problem starts

  • SubSonic 3 and WPF ItemsSource (ComboBox, DataGrid) - selected item not updating more than once 2009-07-21

    When I bind a SubSonic 3 produced IQueryable result to the ItemsSource of a WPF ComboBox or DataGrid, I'm unable to change the selected item in the ComboBox or the DataGrid more than once. I'm using SubSonic and ActiveRecord. Here's an exampl

  • Select Top N records with Subsonic 3 2009-08-15

    I'm using Subsonic for a new project and on one of my pages I'm wanting to display only 5 records that are the top 5 read records. My SQL select statement is select top(5) * from myTable order by reads desc Is this possible to do with ActiveR

  • subsonic join to nested selected statement 2009-09-09

    Is it possible to do a join to a nested select statement in SubSonic 2.2? I am having trouble with this because I have to do a group by... I.E. select conn_company.company_name, SUM(t.quote_grand_total) as 'SUM' from conn_company inner join (SELECT *

  • How to select getdate() from subsonic? 2009-09-10

    I'm using Subsonic 2, SQL Server 2005. Here is how I update intro_accepted column of a Member table record. member.Showintro = true; member.IntroAcceptby = AdminUser.Username; member.IntroAccepted = DateTime.Now; // but I wan't getdate() from SQL Ser

  • subsonic-3 Linq query dose not suport custom class select? 2009-11-02

    I am using subsonic 3. in my case: Entity Class : public class Org: IActiveRecord { public string fieldA {get;set;} public string fieldB {get;set;} } and in my linq query: var linqNodes = from o in DB.Orgs select new TreeNode{ id=o.fieldA,text=o.fiel

  • SubSonic: Selecting all columns with an aggregate 2009-12-02

    How would you best handle constructing this SQL statement in SubSonic? SELECT ac.* , SUM(pt.amount) AS totalPoints FROM tbl_account AS ac INNER JOIN tbl_pointTracking AS pt ON = pt.accountID GROUP BY pt.accountID ORDER BY totalPoints DESC; I kn

Copyright (C), All Rights Reserved.

processed in 0.597 (s). 13 q(s)