I am not running Mike's latest code because it does not build and he didn't update the templates to generate code for the new Load with columns he added. So I am one revision back in the source. My database has tables in multiple schemas and they would not update properly. In SubSonic.Query Update.cs I needed to change the constructo...
I'm real interested in using SubSonic, I've downloaded it and I'm enjoying it so far, but looking at the activity on github and googlegroups it doesn't seem to be very active and looks a lot like a project that's dying. There's no videos about it on tekpub and Rob seems to be using nHibernate for all his projects these days. I don't want...
I used to work with a custom data mapping library, and curently I'm trying to switch to a more widespread ORM solution. After some experimentation, I refined my requirements to the following: able to generate usable classes from database schema (SQL Server support is enough), support for ActiveRecord pattern, programmaticaly configura...
Hi, I have a subsonic version 2.2.0.0. I have a SQL Server 2005 table "Items" with column CategoryId uniqueidentifier null. For this table Subsonic has generated a class with property Guid? CategoryId First I insert an record with some valid CategoryId value. Next I try to update (set to NULL) CategoryId of same record item.Catego...
How can I assign alias to tables with SubSonic 2.1? I am trying to reproduce the following query: SELECT * FROM posts P RIGHT OUTER JOIN post_meta X ON P.post_id = X.post_id RIGHT OUTER JOIN post_meta Y ON P.post_id = Y.post_id WHERE X.meta_key = "category" AND X.meta_value = "technology" AND Y.meta_key = "keyword" AND Y.me...
Hello there, I've got a question regarding how to retrieve the auto-increment or identity value for a column in SQL Server 2005, when said column is not the first declared column in a table. I can get the generated value for a table just by issuing the following code: MyTable newRecord = new MyTable(); newRecord.SomeColumn = 2; newRec...
Hello there, i'm having a issue with the T4 templates for generating code. I'm wondering if anyone can help me with an issue I have. I want to store the connection string for use with SubSonic 3.0 in a default location such as the root of the website (Web.Config or a seperate .config file). This is fine providing the t4 Templates are "...
Anyone know anything about why linq queries are about 6 times slower when querying using active record vs simplerepository? The below code runs 6 times slower than when i query the data using a simple repository. This code is executed 1000 times in a loop Thanks in advance string ret = ""; // if (plan == null) ...
I have a "Notes" table. Notes support one level of threading - in other words you can reply to a note but cannot reply to another reply. So the table looks something like the following: CREATE TABLE [dbo].[Notes] ( [NoteId] [uniqueidentifier] ROWGUIDCOL NOT NULL DEFAULT (newid()) CONSTRAINT [PK__Notes] PRIMARY KEY ([NoteId]), [...
I have been using the SimpleRepository in Subsonic 3.0.0.3 for several months and I have been very happy with it so far. However I discovered today that it does not support type members of type "byte[]". Apparently, I'm not the only one who has faced this limitation. Is there any technical reason why Subsonic does not support this typ...
Hello there, I currently developed an app that connects to SQL Server 2005 database, so my DAL objects where generated using information from that DB. It will also be possible to connect to an Oracle and MySQL db, all with the same table structures (aside from the normal differences in fields, such as varbinary(max) in SQL Server and B...
I have this query: var rights = from gu in db.GroupUsers join g in db.Groups on gu.GroupId equals g.GroupId join gr in db.GroupRights on g.GroupId equals gr.GroupId join r in db.Rights on gr.RightId equals r.RightId where gu.UserId == userId && g.IsDeleted == false select ...
I have a page and it lists bunch of tables in a drop down list. I need to load up a list of columns in the database dynamically. In Subsonic 2.0 it could have been done by Subsonic.Schema.BuildTableSchema but not sure how to do it in 3.0. I tried using the code below but does not work .. SubSonic.Schema.DatabaseTable D = new SubSonic.S...
I'm using SubSonic 2 from within a project and I'd like to specify a different .config file from the default App.config. How can I tell SubSonic to use a specific config file? ...
I'm trying to generate dal from subsonic. But after generating when I'm trying to compile its giving me an error of multiple definitions with identical signatures. This is my app.config. I'm using subsonic 2.0. <configSections> <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" /> </configSections> <co...
I need to generate a table without primary key. Its absolutely neccessary that the table dosen't have primary key. Please help. ...
I've used subsonic(version 2.2) to write a query. How can i return it to a list or collection. And after this loaded into a collection how can i add filtering based on what user wants to see. Actually this is a report query and user can apply filtering so i cannot apply those filtering in the query. Dim qry As SqlQuery = New SubSonic.Se...
I have a table collection in subsonic(2.2) and i want to query it and return the result to a datatable based on user inputs, but the main collctions will remain unchanged. How can I acheive that. Please help. ...
Where can I find an examples of code migration from SubsSonic 2.2 to 3.0. For example we have Subssonic 2.2 code: public static void SavePageModules(PageModuleCollection modCol) { modCol.SaveAll(); } How do we write this method for 3.0. Are Collection deprecated in 3.0. Best regards. ...
I've written this code to generate a collection. I've tried to filter the collection using subsonic.where but its not working. Actually the where clause will change on user input so i cannot add the where clause to the sqlquery and also the datatable will be filled with different data from the collection based on the user input. How can ...