subsonic

Subsonic 3.0 and linq

I'm playing around with Subsonic 3.0 SimpleRepository and try to get menus and menuitems with one linq query, but the menuitems is allways null Menu public class Menu { public Menu() { MenuId = 0; MenuName = ""; MenuItems = null; } public int MenuId { get; set; } public string MenuName { get;...

subsonic - parsing "*" - quantifier {x,y} following nothing

I'm using Subsonics Substage, and have just recieved this error? Any suggestions as to the cause? subsonic parsing "*" - quantifier {x,y} following nothing ...

Subsonic 2.2 and SQL CE

Hi, anybody use Subsonic with SQL Server CE 3.5 ? I try but get an error with Substage 2.2, error talking about PK_TABLE. My tables have primary keys and relations. Can someone help me ? By, Giuseppe. ...

SubSonic 2.1 help needed c#

Hello everyone, I got the following setup for my database: Category Table (Fields: CategoryID(PK), Title); Menu Table (Fields: MenuID(PK) CategoryID(FK), Title); Page Table (Fields PageID(PK), MenuID(FK), Title, Content, CreatedOn); Now for one page I want to know how many Pages a particular category holds. I have no clue how to ma...

Subsonic 3 and Scaffold

In Subsonic 2 I played around with the Scaffold controls to build some quick and dirty admin pages. I need to do the same again but am using Subsonic 3 where I don't see Scaffold anywhere. Is Scaffolding in Subsonic dead? Any other recommendations to get admin pages for db tables (ms sql) up as fast as possible using Subsonic? ...

Join with composite keys in subsonic

I'm trying to make a join on tables that have composite keys. Example: var turnos = from turno in Turnos.All() join turnoService in TurnoServices.All() on new {turno.pk1, turno.pk2} equals new {turnoService.pk1, turnoService.pk2 } select turno; The above sentence throws an exception: ...

Get distinct month and year with SubSonic

I have date type column (MySQL): SELECT invdate FROM invoices; invdate ------- 2009-08-22 2009-07-12 2009-08-23 ------- and I want get month and year like this: SELECT DISTINCT MONTH(invdate) AS invmonth, YEAR(invdate) AS invyear FROM invoices; how to use in C# with SubSonic (SimpleRepository)? TIA ...

Getting a log of the SQL SubSonic is using

Linq2SQL has the great Log property to see what the actual SQL statements that it is generating. Does SubSonic 2.2 have something similar to this? ...

Using OrderBy with custom IComparer with SubSonic

I am trying to call OrderBy() using a custom IComparer on a SubSonic IQueryable like so: IQueryable<FooObject> sortedFoos = FooObject.All() .OrderBy(f => f, new FooObjectComparer()); However when I then try to enumerate over sortedFoos or create a PagedList<FooObject> using it, I get a System.Exception: 'The LINQ expression nod...

Subsonic Linq guid problem

The construtor 'Void .ctor(System.Guid, Int32)' is not supported. this error occured with the following statements: var Test = from r in db.UserRoles join p in db.UserPermissions on new { r.userId, r.roleId} equals new { p.userId, p.roleId } select r; userId is a guid roleId is an integer ...

subsonic 3.0.0.3 activeRecord Between

Hi im using subsonic 3.0.0.3 activeRecord but cant seems to figure between ! select * from orders where orderdate between startdate, enddate; have tried IQueryable<orders> myOrders = order.All().Where(x => x.order_date).isBetweenAnd help much appreciated, please make note of version number, and that any answers actually work for that...

Subsonic and the VB.net 2005 interop toolkit

I have an application I am converting over from vb6 to vb.net 2.0/3.5. Using Subsonic 2.2 and the vb.net Interop Toolkit 2005. Cannot seem to get the .net form using subsonic to work inside the interop environment. It keeps saying it cannot find the subsonic service provider in the app.config. But I know it is there. Has anyone used thes...

SubSonic group by

Hi, I'm doing a group by with subsonic but I'm not getting the results expected. var settings = from setting in setting_query group setting by setting.ColumnName into g select g; var items = settings.ToList().Select(s => s.First()).ToList(); var items2 = settings.Select(s => s.First())...

Lambda Func delegate using interface

I have a class implementing an interface, and I need to return a Queryable<> list of that interface, given a certain Where predicate : public interface ISomeInterface { int ID{get;} IQueryable<ISomeInterface> GetWhere(Func<ISomeInterface,bool> predicate); } public class SomeClass : ISomeInterface { public static IQueryable...

Grouping with SubSonic 3

I have the following table "GroupPriority": Id Group Priority 1 1 0 2 2 0 3 3 0 4 2 1 5 1 1 6 2 2 7 3 1 I would like to group these on "Group", order them by "Priority" and then get the one in each "Group" with the highest Pri...

SubSonic 2.2 SqlQuery object generates very different sql for WHERE...IN statement for SQL Server 2008 and SQL Server 2005

Does anybody have an idea why SubSonic 2.2 SubSonic.SqlQuery object would be generating very different sql for the same C# code when running against SQL Server 2005 or SQL Server 2008? I have a site that's been running for a while on SubSonic 2.2/SQL Server 2005. I just upgraded the DB to mssql 2008 and am encountering the following er...

Pattern for GridView binded to ObjectDataSource - late save

I have a GridView which I am binding to my service layer. I want to be able to allow the user to edit the grid, but I do not want to save the grid as the user is clicking update on each row. I would like to update all of the edited/added/deleted rows when the 'save' button for my entire form is submitted. I have my service layer config...

Merge with Subsonic Service Layer?

Hello, I am grabbing a collection of my objects from Subsonic service layer. I am modifying these objects via GridView. I now want to "merge" this new set of data into my database, same tables that data originally came from. DataSet has a merge method I believe, wondering if I can do the same in SubSonic. Thanks! ...

scaffold in subsonic

Hey all i am using SubSonic 2.1 Version, how to access the scaffold control in our project. Pls help me with code. Regards Kishore ...

SubSonic3 StoredProcedures.cs empty

I just installed SubSonic3 to have a look at it. I manage to create the all the classes with the T4 templates except the Stored Procedures. The StoredProcedures.cs stays empty, even if I retry with Run Custom Tool. Is there a way to see some kind of output when the classes are created or has anybody had this problem before? ...