I would love to have a list of SubSonic conventions. I saw http://bit.ly/3punQZ but it didn't seem complete as of today and it seems wrong. It says "table names should be singular". My understanding is that the convention is plural names for table names. I am also not clear on how to name lookup tables. ...
I'm building a small project with SubSonic 3.0.0.3 ActiveRecord and I'm running into an issue I can't seem to get past. Here is the LINQ query: var result = from r in Release.All() let i = Install.All().Count(x => x.ReleaseId == r.Id) where r.ProductId == productId select new ReleaseInfo ...
I am new to SubSonic so please be gentle :) I am getting "Specified cast is not valid" when performing a save on my object using the SimpleRepository. Unfortunately I have no idea how to track down what is causing the exception. Any help would be much appreciated. ...
I'm looking for possible ways to persist the following classes. Subsonic SimpleRepository looks like it might work, and people have said it should, when I asked a more general question. But I've been unable to find a single example of how to do this - or at least one I could understand. Can anyone point me to an example, or tell me ...
I'm using the latest version of SubSonic (3.0.3). I'm having a problem with building my solution when my assembly is signed. I get an error stating the 'SubSonic.Core' assembly does not have a strong name. Can I not use SubSonic with a signed assembly? ...
I have something that looks like this foreach (var user in NewUsers) { var dbUser = new User {FirstName = user.FirstName}; dbUser.Save(); } That is too many inserts into the database. Can I do something like? User.BulkInsert(NewUsers); Thanks. ...
Hey all, I've been playing with SubSonic's SimpleRepository, and it's awesome. However, I would like to know if there's an easy way to apply pending changes to a production system. Previously, I used SubSonic 2's "Migrations" via a batch file; when I was ready to move to production, I'd just run all the pending migrations against the p...
Hi. I have something like this: Order order = new Order(); Item item = new Item(); order.Items.Add(item); order.Save(); How can I do this with Subsonic? The method that refere to a related table is IQueryable. ...
I'm current evaluating SubSonic 3 for use with a legacy DB - IE very little ability to change the current structure. Long story short SubSonic 2 handled our composite foreign keys pretty well - however we're looking for something that will providew linq and all the rest that goes along with SS3. So far I've found that SS3 using both th...
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 am looking for any examples which ideally cover several possible combinations ( SimpleRepository, ActiveRecord , POCO ) - something similar to Brad Abrams http://blogs.msdn.com/brada/archive/2009/10/27/index-for-business-apps-example-for-silverlight-3-rtm-and-net-ria-services-july-update.aspx but ORM is SubSonic. ...
I am using subsonic 3. in my case: Entity Class : public class Org: IActiveRecord { public string fieldA {get;set;} public string fieldB {get;set;} } and in my linq query: var linqNodes = from o in DB.Orgs select new TreeNode{ id=o.fieldA,text=o.fieldB}; var nodes = linqNodes.ToList(); the TreeNode class is my custom class for ...
Is is possible to set the seed for the identity column of a table using SubSonic? ...
I use SubSonic 3.0.0.3 ActiveRecord with ASP.NET MVC and it is very nice. However, we run on IIS 6 and I tend to have quite a few issues with speed. I dont know if this is me being too paranoid but I was thinking of using SubSonic with just a normal ASP.NET WebForms website. Please forgive me for being thick but I'm so used to models and...
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: ...
Please somebody help doing the oldest things on SubSonic.. like CRUD. Please tell how can i do an INNER JOIN / LEFT JOIN relationship queries. thank you very mucg. ...
hey all, my question is whether SubSonic will work in Visual Web Developer 2008 Express Edition, and if it works what is the installation steps. Thanks in Advance Kishh ...
I'm trying to figure out how to do a querey with a where blah=blah or blah=blah2 with subsonic 3 linq and I can't figure it out. My query at the moment looks like this: var ddFaxNumbers = from f in rf_faxnumber.All().Where(f => f.assigned == null).Where(f => f.location == currentFaxNumberRecordData.location) ...
Yes, there is a method max with 13 overloads, none it's simply the name of the column. Something can post an example in VB.NET? ...
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...