subsonic3

SubSonic 3 and RESTHandler

Hi, I was about to start modifying the ActiveRecord.tt template to roll my own toJson() method when I thought I really ought to see if I'm about to re-invent the wheel. I quickly came across the RESTHandler class from SubSonic 2 and I was wondering if anyone has any thoughts about what's invloved with getting it to play nicely with SubS...

Modifying a SQLLite database schema and data via SubSonic 3 within a transaction

I'm using Visual Studio 2008, C#, SQLite via System.Data.SQLite with SubSonic 3. My application has gotten to a state where I need to upgrade the database schema (add columns, triggers, etc) then add new records via SubSonic generated ActiveRecord objects - all within the scope of a single transaction so that any failures could be nicel...

Has anyone had any success with Subsonic3, linq, MySQL and Stored Procedures

Hi, I have been trying to get MySQL stored procedures running with the linq templates in Subsonic3. I added some functions to the MySQL.ttinclude file that seems to have generated the stored procedure reference classes. However when I run the code and call the stored procedures I seem to always get NULL results: public DataSet SPTot...

SubSonic 3.0 ActiveRecord - Preferred approach building object graph?

Say I have a forum system with Threads, Posts and Tags. The structure is the same as StackOverflow: Threads have a 1-many relationship to Posts, and Tags have a many-many relationship to Threads. The (simplified) tables: Thread ------ ThreadID int PK Title varchar(200) Tag ---- TagID int PK Name varchar(50) ThreadTag ----------- T...

Subsonic 3.0 and large SQL Database

Is there a way to limit the code generated to specific tables in a database? My database has a few hundred tables and I only really want to use SubSonic on a handfull of them. ...

asp.net mvc data annotation with subsonic 3.0

Hi Has anyone built an application using asp.net mvc with data annotation for validation and subsonic 3.0 for BOL generation? I am using IDataErrorInfo in partial class at the moment and would like to move to data annotation but i'm not sure how to do it with subsonic 3.0 has my object generator. I'm using MVC 1.0 I would like to fi...

Achieve equivelent of T-SQL ROW_NUMBER+OVER in Linq

Is it possible to achieve the following in Linq? What I am trying to get is a list of records that have a column that displays the row number starting with 1. I need to display the row number in a gridview control to denote visually to the user how many rows have been populated. Why you ask? The user needs to enter an exact number of...

Subsonic and GoDaddy

Hi I'm using GoDaddy Deluxe Plan Hosting and SubSonic 3.0. I have problem with Security Exception. I searched the net and found several older solutions, like this one: http://ozzieperez.net/blog/?p=9 (this one is from 2 years ago) I tried this and I still could not manage to make it working... Can someone please confirm that SubSonic...

How I can add undo functionality with SubSonic.. thanks in advance

How I can add undo functionality with SubSonic.. thanks in advance ...

column name "descriptor" -> 'MyDAL.CompanyTable.Descriptor' hides inherited member

I wanted to take advantage of SubSonic's default behavior to find the first non-key string column to use as the object description. Usually I just name that colun description and then [bracket] it in t/sql. This time I decided to name the column "Descriptor". That leads to this warning - Warning 3 'SW21Console.DAL.CompanyTable.Descr...

Subsonic 3.0.0.3: issues with load slowdowns

Hi. I'm using subsonic 3.0.0.3 (active record) quite a simple database really, have trusted in its abilities but i am really getting let down by how incredibly slow it it to do anything. For some reason it likes to run through things more than once. For example: var newitem = new new_quote_item { quote_id = Convert.ToInt32(newQuoteI...

Subsonic 3 with Oracle support

Is there an oracle ttinclude file available anywhere? ...

Subsonic Question, is it possible execute templates during runtime ?

Hi All, Before ask my question, i have to say that subsonic is wonderfull tool, i realy like it. I have an application which is createg domain layer during the runtime itself. I mean It has got customizable entites and when the entity added or any entity schema changed my model layer compiled again in the runtime according to changed dat...

Where can i see the query generated by subsonic?

I need to see how subsonic generates the SQL Query string. ...

How to automate Subsonic 3 audit fields so they work like Subsonic 2

I am using SubSonic 3.0.0.3 in SimpleRepository mode. I was wondering how to get Subsonic 3 to automatically create and populate the createdon, createdby etc audit fields that were standard in version 2.x . Is this something I have to configure with the T4 templates? ...

Outer join in LINQ Problem

Id like to perform an outer join with the second join statement in this query, I keep getting weird errors! (it must be the 3rd RedBull) var Objeto = from t in Table1.All() join su in table2.All() on t.Id equals su.Id join tab2 in Table1.All() on t.PId equals tab2.Id //<-I want it here select new ...

SubSonic Outer Join

There seems to be a Bug with the Outer Join statement in SubSonic 3, or maybe it's just my ignorance, but the following craps out: var Objeto = from t in Table1.All() join su in table2.All() on t.Id equals su.Id join tab2 in Table1.All() on t.PId equals tab2.Id into gj from j in gj.DefaultIfEmpty()...

How do I refresh the SubSonic T4 Template generated code?

I've just started using SubSonic 3 and I'm using the ActiveRecord T4 template. If I make a change in the database (add a column to a table for example), what is the correct method for forcing the code produced by the T4 templates to be re-generated? At the moment I'm just deleting the ActiveRecord folder in my project then dragging the...

How Can I Get the Identity Column Value Associated with a SubSonic 3 LinqTemplate Insert?

I am using SubSonic 3.0.0.3 along with the Linq T4 Templates. My ProjectRepository, for example, has the following two methods: public int Add(Project item) { int result = 0; ISqlQuery query = BuildInsertQuery(item); if (query != null) { result = query.Execute(); } return result; } private ISqlQuery Bui...

Delete using 2 tables join and wheres using subsonic 3

I have 2 tables POST (idpost, user, text) COMMENT (idcomment, idpost, text) i want do delete all comment with post have a user like "usertest" delete from COMMENT c join POST p on c.idpost = p.idpost where p.user like 'usertest' who i make this in subsonic 3??? i try something like this, but, offcourse, don't work hehehehehe COM...