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;...
I'm using Subsonics Substage, and have just recieved this error? Any suggestions as to the cause?
subsonic parsing "*" - quantifier {x,y} following nothing
...
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.
...
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...
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?
...
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:
...
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
...
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?
...
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...
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
...
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...
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...
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())...
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...
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...
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...
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...
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!
...
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
...
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?
...