-
My solution deals with modifying the Subsonic source code. This is pretty easy to do, took me less then 5 mins. This is really useful if you have more then 2 stored proc's that don't take arguments. http://www.jasonstiefer.com/blog/post/2008/11/SubSonic-with-Stored-Procs.aspx
-
i just like to know if can create this sql i subsonic SELECT Id, Title, Body, Slug, CreatedOn FROM Posts WHERE (DATEPART(Month, CreatedOn) = 9) AND (DATEPART(Year, CreatedOn) = 2008) ORDER BY CreatedOn DESC
-
I'm using 2.1 and am updating a record. When I run the update I get the error 'Incorrect syntax near the keyword WHERE'. I've seen this is a bug and I've applied the patch to the SQL2005 generator, regenerated the code and got the same error. I even tried what was referenced here...
-
Question: according to the 'Config Options' documentation on the main site, one HAS to name their stored procedures in the following manner to have SubSonic associate them with the table/class: "_DestinationClassName_RestOfStoredProcedureName". Is there a way to override this, either...
-
Hi there, I'm attempting to use the repository pattern with a new project, and I'm looking for an efficent way of populating two distinct objects from a single view. The two objects are related, and one sits as a property of the other. I've got no problem manually binding them, but it's...
-
Hi, We have 2 schema on the same MYSQL Server. The Tables are in InnoDb Format, and we have Foreign Key crossing over the 2 schema. Is there a way to have the DAL running well in this config? Does Subsonic allow Foreign Key acrossing schemas, and should it work? We try to set 2 provider, 2 GeneratedNameSpace...
-
Is anyone else having problems with subsonic not closing connections? It opens the connection and then does not close the connection and waits on the garbage collector to close out the connection. This is making multiple connection to the sql server. I am getting errors like Timeout expired. The timeout...
-
I am using Subsonic for the first time and having a hard time accessing a return value from a Stored procedure. Following is my stored procedure [dbo].[sp_InsertUser] @UserName varchar(50), @UID uniqueidentifier OUTPUT AS BEGIN IF EXISTS(SELECT * FROM Users WHERE LOWER(@UserName) = LOWER(Users.UserName...
-
Can anyone tell me if you're able to exclude certain tables, views and SPs when it's generating code? I'd also like to know if you can stop the ability to access the tables directly and only enable use of stored procedures through subsonic? Thanks, Frankie
-
Hi, I've decided to post this information because It may be relevant to others and because I think SubSonic is very usefull. I was working in a simple project involving an Oracle database but the production database was version 8.1.7 and in our development environment we were working in a 10g version...