I have a problem in subsonic 3.0.3. When i use subsonic to genarate code , i can use all table in database But i can't see any store procedure which had been defined in database. Please help me. P.S. : I am using MSSQL ...
I've used SubSonic's ActiveRecord T4 templates in a couple of projects. Today I added the same templates from one of these projects (without the generated .cs source files) to a new project. For some reason when I run the T4 template code generator, instead of generating: ActiveRecord.cs, Context.cs, StoredProcedures.cs and Structs.cs...
I have a problem while creating a web application using LinqTemplate here is the explanation step wise.... (1) I have created a database Database1 with a table name UserTest with one column name UserId with (uniqidentifier,not null) datatype , username (nvarchar2(20),null) (2) I have created a classLiberary Project where i have used Li...
I want to have a baseclass that will assign a DataGridView's datasource property. I am using the ActiveRecord approach so all my code generated classes are of IActiveRecord. IRepository needs my class to instantiate it. I cannot seem to get this to work What I want to do is something like this.. IActiveRecord GridObject; public voi...
Would like to initialize @ run-time as needed with the connection string coming from a non app.config source ...
SubSonic 3 does not output stored procedure parameters in the order specified by the stored procedure definition. Instead, SubSonic outputs these in alphabetical order. This is an undesired trait. To correct this issue, you will need to change several lines within the "SQLServer.ttinclude" file. Locate the "GetSPParams" function withi...
I am trying to use Subsonic for SQLite. I got an exception "SQLite error near ".": syntax error". VS 2008; Subsonic 3.0.0.3; SQLite 3. How I can to resolve it? Also, cananybody provide an project example with Subsonic for SQLite included. ...
Here what I would like to do: var groups = from g in Group.All() where g.FirstDay < startDate && (g.LastDay == null || g.LastDay >= startDate) select g; FirstDate is a dateTime and LastDate is a nullable datetime. I'm getting an "System.InvalidOperationException: The operators of the 'LessThan' do not correspond with parameter...
I download the latest version of Subsonic(3.0.0.3) but when I add the T4 templates in my solution in Visual studio 2008 SP1, the auto-generation don't work. If I right click on the template files also the "Run custom tools" is not present. What I have to do to make visual studio able to generate code from T4 templates? ...
I have a baseclass that handles returning data from the relevant class/table. I want to have some way of specifying the columns to display. Maybe have a public columns List that gets assigned with all column we want to display? This is what I have but its not right. public void SetupGrid<T>() where T : class, new() { ...
Hi, I have implemented Subsonic 3.0 successfully, but when ever a database call is made the table names are added with a plural values. Can anyone guide me on this. EG:- var categories = new Select().From<Vendor>(); the db call goes as "SELECT * FROM Vendors" Thanks in Advance Arun.M ...
I'm using Subsonic 3 and am just starting the process of putting my application into production. Locally, I develop using SQL Server 2008 but the production environment is using SQL Server 2000. I am getting the following error for paging: 'ROW_NUMBER' is not a recognized function name. Description: An unhandled exception occurred du...
Looking at this line in the Settings.ttinclude string CheckNullable(Column col){ string result=""; if(col.IsNullable && col.SysType !="byte[]" && col.SysType !="string") result="?"; return result; } It describes how it determines if the column is nullable based on requirements and returns either "" or "?" to the ge...
When I go to run the t4 templates, the result comes out "Compiling transformation: The name 'TableSpaceName' does not exist in the current context" -- any ideas on this? I thought it might be a namespace/reference issue, but it doesn't seem to be part of the ODP. This is one of those "it has to be something stupid" ... why? I've got su...
I have the following code which is in a base class. MyApp.MyDB = new MyApp.MyDB (); IRepository<T> repo = new SubSonicRepository<T>(db); CurrentTable = repo.GetTable(); var s = db.SelectColumns(columnList.ToArray()). From(CurrentTable.Name). OrderAsc(CurrentTable.Descr...
I am checking whether my class IsDirty, if so the user gets prompted to with a "do you want to Save" message. If they click yes, it calls a Save however I am stuck in a loop because Save does not clear out the dirty columns. Should it? *BUMP* ...
When saving a row that has a integere primary key following exception is thrown in the VB version: 'Public member 'ChangeTypeTo' on type 'Decimal' not found.' This happens in ActiveRecord.VB file line 3406: Public Sub SetKeyValue(value As Object) Implements IActiveRecord.SetKeyValue If value IsNot Nothing AndAlso value ...
I'm trying to using the Subsonic Fluent query interface to create a simple inner join between two tables: [SearchJobResults] PK SearchJobResultId int Name string Desc string [ParseResults] PK ParseResultId int Name string SearchJobResultId int There is a 1 to 1 relationship between these tables. Keep in mind, I'm not using ActiveRe...
Hi I just downloaded subsonic 3.0 and I want to work with stored procedures. I don't know which template to choose: ActiveRecord or LinqTemplates. I don't really know the difference. I know that I don't want to deal with Linq code. I just want subsonic to generate classes based on tables and also their relationships (if possible) an...