Browse by Tags

Distributed Software Concern - Can the Connection Strings Change without recompiling?

We have a distributed application. The customer can use Access or SQL just by changing the connection string. Will it still work if we use Subsonic, or would we have to have two separate versions of the software. It sounds like you need to regenerate Subsonic if you change your connection string. That...

Posted to Getting Started (Forum) by Matt_Weber on 04-30-2008
database structure exposed in source code

Hi, I was always told that embedding SQL in source code was bad practice in terms of security - showing database structure in source code. Wouldn't this be the same for the subsonic "query" method calls which show the database structure? Thanks, Kenny

Posted to Getting Started (Forum) by subflux on 04-30-2008
Field Concatenation

I was wondering if the below SQL Is this possible using the SELECT object? Select *, Firstname + ‘ ‘ + lastname as fullname from table

Posted to Version 2.1 - Pakala (Forum) by vzaffiro on 03-25-2008
Re: Are multiple references to the same table handled?

After a couple of days with no answer I figured that I'd take a crack at implimenting this feature -- I believe that I have success!! First of all I have only implimented this as a feature for the FROM table when you use the CreateJoin(string fromTable, string fromColumn, string toTable, string toColumn...

Posted to Version 2.1 - Pakala (Forum) by dhigginx on 03-22-2008
Re: Are multiple references to the same table handled?

When the Select includes .InnerJoin(ParaSonic.Lookup.LookupIDColumn, ParaSonic.CustomerContact.DispoCodeColumn) .InnerJoin(ParaSonic.Lookup.LookupIDColumn, ParaSonic.CustomerContact.MarriedIDColumn) I Get a SQLQueryException: The objects "dbo.Lookup" and "dbo.Lookup" in the FROM clause...

Posted to Version 2.1 - Pakala (Forum) by dhigginx on 03-19-2008
Inner Join Issue

First, let me say SubSonic rocks. I have only just started using it but the time it has already saved me has been huge. I think there is an issue with Inner Joins (built from Pakala Trunk on 3/5 - 3/6). Or I am so sleep deprived that I am missing something obvious. My code: Dim dt As New DataTable Dim...

Posted to Version 2.1 - Pakala (Forum) by k_man on 03-06-2008
Group By?

Hi. i'm new here. i'm looking for the option to do group by to a field but i can't find it. is there any option for it? thanks.

Posted to Getting Started (Forum) by parnar on 02-25-2008
SQL: select * from foobar WITH (NOLOCK)

For performance, in a lot of situations we'll use the WITH (NOLOCK) option to tell SQL server we don't care about record locking for the data in a certain table. It results in a substantial performance boost when appropriately used. How can I use this with SubSonic? Thanks, David

Posted to Getting Started (Forum) by DavidJBerman on 01-09-2008

Page 1 of 1 (8 items)