in
All Tags » SELECT (RSS)

Browse by Tags

  • InnerJoin NullReferenceException

    Hi guys, We've come across a bug where the following code throws a NullReferenceException (on SVN r432): SubSonic.SqlQuery q = new Select().From(Northwind.Tables.OrderDetail) .InnerJoin(Northwind.Tables.Product) .Where("CategoryID").IsEqualTo(5); A workaround for the time being is for us...
    Posted to Version 2.1 - Pakala (Forum) by stevemason on 05-07-2008

  • Simple Examples of Select, Insert, Update, and Delete

    Ok....total n00b here. Can someone give me some simple examples of how to use SubSonic once the DAL is created. Thanks!
    Posted to Getting Started (Forum) by KorbanD on 05-03-2008

  • New select() for safe column names DB.Select() vs new Select()?

    Hi there, In the svn builds I noticed a new overload method for Select() constructor for safe column names: http://code.google.com/p/subsonicproject/source/detail?r=422 Added overload to the Select() constructor to take typed columns for safe column names. For example, you can use this query: "Select...
    Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 04-22-2008

  • BuildSQLStatement

    Hello All! I am trying to create a dynamic sql statement so I can add it to a sqldatasource object. Here is my code: SqlQuery s = new Select().From(namespace.Account.Schema); s.WhereExpression("state").IsEqualTo("FL").; string sql = s.BuildSqlStatement(); Problem: The where clause...
    Posted to Getting Started (Forum) by vzaffiro on 03-25-2008

  • Re: Field Concatenation

    Thanks kbradl1! The Select command didn't work for me(Incorrect syntax near '*') but I was able to get the QueryCommand to work. This leads me to a new challenge! I am working on a grid view control and I am trying to enable paging. How would I do this in the QueryCommand?
    Posted to Version 2.1 - Pakala (Forum) by vzaffiro on 03-25-2008

  • Re: Field Concatenation

    This might work, although I haven't tested it: VB: Dim sel As New [Select](DataService.Provider, New String() {"*", "Firstname + ' ' + Lastname As Fullname"}) However this is the way I would do it: VB: Dim fquery As New QueryCommand("Select *, Firstname + ‘ ‘ + lastname...
    Posted to Version 2.1 - Pakala (Forum) by kbradl1 on 03-25-2008
Page 1 of 1 (6 items)