subsonic

Subsonic 3 and GridView

Is there some docs or examples, about best practices working with Subsonic3 and Gridview? Sorting, paging etc... In Subsonic2 there was quicktable, does Subsonic3 have something simnilar? ...

subsonic 3.0.0.3 multiple database connection failover

hi there, am using MVC and Subsonic 3.0.0.3 but i cant seem to pin down a specific point for multiple database connection. normally in normal .net i would have my 2 strings in the web.config file and have a database class for my project, within this db class i would do something like this: try { conn.ConnectionStr...

How do I use SimpleRepository without the migration approach?

I am evaluating SubSonic for use in Phase 2 of a large project. This is an ASP.NET project, with 700 tables in a SQL Server database. We are planning for our domain model to consist of POCO classes to assist with an offline access requirements we have. I believe that the SimpleRepository pattern would be among my best options. Since ...

SubSonic Return ExecuteSingle for Stored Procedure

I wish to return a single ScPollOption item using a Stored Procedure via the code below: public ScPollOption FetchPollOptionByID(int optionID) { StoredProcedure sp = SPs.ScPollOptionGetOptionByID(optionID); return sp; } When working with a query I would use: ExecuteSingle<ScPollOption>() but SubSonic only al...

subsonic 3 query syntax

Anyone know of a website that shows various Subsonic 3 query types? I used to use various SS 2 sites that would go through examples of how to get varying types of data. However, am now using SS 3 and am new to .net 3.5 so while the SS site does provide three or four example queries it doesn't explain how they work and there aren't enough...

SubSonic PrimaryKey not autoincrement

Does current version of SubSonic support PrimaryKey (Int) which is not Autoincrement? How? PS: If I don't use SimpleRepository() I can save new record with assigned Id so more or less I can go on, thz. ...

subsonic 3.0.0.3 multiple database connection failover

Possible Duplicate: subsonic 3.0.0.3 multiple database connection failover re-posted this is never seemed to actually go up onto the listings ????? bizzare hi there, am using MVC and Subsonic 3.0.0.3 but i cant seem to pin down a specific point for multiple database connection. normally in normal .net i would have my 2 stri...

how best managing paging with subsonic 3.003

hi everyone i'm really engaged with subsonic but I'm not sure how make it work with paging i mean how can i get "the page" in a list or how is the best way to managing the total table in my base, page by page youll see i tried three things: m02colegio is an class generated from activerecord IList<m02colegio> loscolegios; loscoleg...

SubSonic GetPaged method - different index needed in unit test

I'm using SubSonic 3, and am using the ActiveRecord approach. I have a simple query in my controller: var posts = from p in Post.GetPaged(page ?? 0, 20) orderby p.Published descending select p; The "page" variable is defined as an nullable int (int?). Here's the problem, when I run the following test, it work...

How do you handle SubSonic 'relationships' with migration?

According to this article: http://subsonicproject.com/docs/3.0%5FMigrations Bottom line: if you're a developer that is concerned about database design, migrations might not be for you. Ok, that's fine, I can treat the database as simply a persistent repository of data that doesn't contain any business logic. In other words, a glorifie...

SubSonic Active Record

I recently decided to give SubSonic a try in my new project. I really how simple it is to generate all the models and database queries. But I have encountered some problems. But I think it generates the models wrong (Or maybee I need to create simpler relations). For an example; In my database shown in part in the picture below it gener...

SubSonic3 - Column 'CategoryID' cannot be null

I'm using Subsonic with SimpleRepository: using System; using System.Collections.Generic; using System.Linq; using System.Text; using SubSonic.DataProviders; using SubSonic.Repository; namespace SubSonicTest { class Program { public class Product { public int ProductID { get; set; } publi...

error while mapping database schema

When I try to map with subsonic 3.0.0.3 database, i get error: "Running transformation: System.InvalidOperationException: Sequence contains more than one matching element..." Where i should look for error? ...

SubSonic vs. Castle ActiveRecord

For an upcoming project C# code needs to be written around a legacy Oracle database. It will be very data centric, because most of the code will deal with data manipulation -- there are almost no business rules. So I decided against a full blown ORM and opted for an Active Record approach. I come across two options: SubSonic and Castle ...

SubSonic Batch insert

I am familiar with SubSonic 2.2 and am coming up to speed with 3.0 and am unsure of the best way to do something. I have a CSV file that I am parsing and then inserting the records into the database. I want to be able to process the batch of inserts all at once. IE I would like to parse through the records and add them to a List inser...

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...

SubSonic - Using Sprocs vs in-line code-behind query?

I'm curious about at what extent I should be writing sproc's. Obviously for actions that require transactions, etc. However for a simple validation against one table and values within, is it still recommended to use a sproc rather than doing the SubSonic query in the code-behind? In one respect it does make sense to write the sproc, a...

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...

Adding properties to an existing object retreived using SubSonic

I think this is more of a polymorphism question but it applies to SubSonic table objects... Here's the thing (and I love this one): TblUser userObj = new TblUser(1); Which fills userObj's properties with all of PK=1's goodies. Now, I'd like to add more properties to the existing user object, for example, an ArrayList property of say,...

Update command in database

I found that auto-generate update command is: exec sp_executesql N'UPDATE [Category] SET Parent_Category_Id=@up_Parent_Category_Id, Index=@up_Index WHERE [dbo].[Category].[Id] = @0', N'@up_Parent_Category_Id int,@up_Index int,@0 int', @up_Parent_Category_Id=14, @up_Index=2, @0=16 I don't think that is a good command, we shou...