subsonic2.2

Correct replacement for ExecuteScalarInTransaction Subsonic 2.2

I'm upgrading an application from Subsonic 2.0.3 to the latest 2.2 version. What's the best practice way to replace the ExecuteScalarInTransaction(command, transation) method? Here's a sample of a method I'm replacing: public static void ActivateAccount(int parentId, int childId, int playMode) { SqlConnection conn1 = DataUtil.Get...

Subsonic 2 Order By sorting not working

Hi, I am trying to sort (ORDER BY ) a subsonic DAL collection New templateController.FetchAll().OrderByDesc("Name") But it is not sorting. Am I missing something? ...

Why can't I see the SubSonic Generated namespace

I have Generated a Namespace using SubSonic and I can see it in the class view but it will not show up in Intellisense and will not compile. What am I doing wrong? I did this with no issues a few years back but I'm at my wits end. ...

Can't find the SubSonicService section of the application config file

Hi When i try to open my MainForm in Visual Studio in the designer, this error pops up instead of the designer of the Visual Studio. Can't find the SubSonicService section of the application config file at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value) at System.ComponentModel.Design.Serializa...

SubSonic generation of tables with columns as ColumnX

This doesn't make much sense to me. We had this happen twice recently when generating SubSonic objects for a database table or view columns got renamed to ColumnX. The first time it made sense because the column name is Value, a C# keyword. But the second time it happened, the table's column name is Grade, which is not a keyword or re...

How does one do an Oracle top-n (paged) query in SubSonic 2.2?

(Disclaimer: I changed/obfuscated some of the variable/table/column names here for security reasons. Please forgive me if something looks a little off.) I am building a front-end to an Oracle 10g database, and I'm trying to get paged data. Aside from paging, the following SubSonic 2.2 code gives me what I want, in the order I want it:...

SubSonic - How can i create my business logic layer

Hi Guys Im new to subsonic and generally this was of programming, i usually develop from a rad perspective so using the visual studio dataset designer, but i wanted to start looking at developing n teir approach. Ive never used a business logic layer, (naughy) normally my code behind takes care of validation so to speak aswell as gener...

Subsonic - Where do i include my busines logic or custom validation

Hi Guys Im using subsonic 2.2 I tried asking this question another way but didnt get the answer i was looking for. Basically i ususally include validation at page level or in my code behind for my user controls or aspx pages. However i haev seen some small bits of info advising this can be done within partial classes generated from s...

Is there a way to use T4 templates with Subsonic 2.2

I understand Subsonic 3.0 is the latest and greatest, and I understand Subsonic 3.0 has T4 templates. But Subsonic 3.0 is not backwards compatible with Subsonic 2.2, meaning, my project with hundreds of code files written in the subsonic 2.2 query language will not work in Subsonic 3.0. So my question: Is there t4 templates someone ...

SUBSONIC using subcommander via VS2008 causing following errors - help please

Hi Guys Ive been using subcommander to generate my dal. Im using vb.net and sqlexpress and .net 3.5 My webconfig looks like this <!-- add subsonic in for dal--> <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" allowDefinition="MachineToApplication" requirePermission="false"/> </configSections> <connection...

Fixing the SubSonic 2.2 Calendar, How do I get RegisterClientScriptInclude calls to render when control is not visible?

Hello, I really liked the SubSonic 2.2 calendar control. It is a .Net implementation of the old Dynarch calendar found here. So I did what any developer would do and I swiped all the code for the calendar and put it in it's own library. Unfortunately the calendar does not play nice with an update panel. I got help here for getting the...

Help with SubSonic 2.2 binding

I have the following tables TUser (user_id,firstname,lastname) PK user_id TGroup (group_id,name) PK group_id TUsersGroups (user_id,group_id) PK (user_id,group_id) FK (user_id) FK (group_id) I need to bind to a DataGrid the TUsers, showing the following columns firstname,lastname and groupname (the NAME taken from th...

many to many relationships - can anyone explain how Subsonic 2.2 handles this

Hi I have a link table to link users to qualifications and I am trying to work out if there is any special way subsonic handles this. I have found this page in the documentation but it doesn't explain what it actually does. I know I can do a query as such: QualificationsCollection col = DB.Select().From<Qualification>() .InnerJo...