I followed the steps on this tutorial video by at subsonic website. Everything seems to be self explanatory but when I copy the .tt files into my Visual Studio nothing happens. I have read other question relating to this problem on this website but they don't seem to fix this problem. I also went into the regedit to find out the gener...
Hi, I'm wanting to use an ORM tool for an asp.net web app I'm working on. I've put together all my classes and just want to have the data persisted. I downloaded SubSonic 3.0 and began using the simple Repository...which was brilliant. I'm new to ORM tools as my first experience commercially was the DataSets/Stored Procs world for a few...
Hi, I'm trying to use Subsonic 3.0.0.3 with an existing web site created in vb.net. I've added a reference to SubSonic.Core.dll and added the ActiveRecord tt/ttinclude files. I also added a contextmenu entry to run the t4 templates using instructions I found here. Whenever I try to run any of the tt files, I receive the following except...
I've looked all over the SubSonic website, but I can't find anything about its licensing. With the project I am working on, I need to list all the open source projects I use along with their licenses. ...
Hi I am having the following error {"Unable to cast object of type 'System.Linq.Expressions.MethodCallExpression' to type 'SubSonic.Linq.Structure.ProjectionExpression'."} System.SystemException {System.InvalidCastException} And My Code is var results1 = from la in db.LoanApplications join ld in db.LookUpDeta...
Geeting, I'm using Compact Framework 3.5 and have tenatively settled on a custom build of Subsonic 3.0 to do data access. The trouble is that I am used to developing model-first but am also interested in keeping control of my DB schema. Therefore, neither ActiveRecord or Repository appears to meet my needs, and I want to use my existing...
I was trying to use Subsonic to generate my DAL, but I noticed a bug while generating Classes using LinqToEntities T4 templates. I noticed that one of the columns in a table was having the type tinyint, while generating a Property for this column it created one which returns a byte[] instead of a byte. Also another Table had a Column na...
I'm big on doing the majority of my applications in code behind, even GridViews I try to do almost entirely in code where I can. One problem I keep running into with SubSonic3 is being able to define a variable then create a if or case and assign a value to that variable inside the various blocks of code, then assign that variable as the...
Hi, I'd like to use a mocking framework as well as an IOC framework with my latest project, based on subsonic 3 (ActiveRecord) and ASP.NET MVC. I'd like to use Moq for mocking and Castle-Windsor for IOC. Anyone got any advice or recommendations based on these choices? Any bumps in the road I should be aware of? Chris ...
I saw in an earlier post here on stackoverflow a example on many to many relations. To keep it simple, lets have a look at these classes : public class Role(){ public int Id { get; set; } public string Rolename { get; set; } public string Description { get; set; } } public class User(){ public int Id { get; set; } p...
What could possibly be wrong here? public Contact GetContact(int key) { var contact = new ContactManagerDB.Select .From<Contact>() .Where(ContactsTable.IdColumn).IsEqualTo(key) .ExecuteSingle<Contact>(); return contact; } ReSharper 4.5: Cannot resolve symbol Select. Oh,...
I've made some modifications to SubSonic 3.0 in order to allow it to run on .Net Compact Framework 3.5, as well as use more complex entity-table mapping and entity tracking (so it's more like Linq-to-SQL). I'd be interested in contributing these back to the project, but I don't find any documentation on how to contribute to the project, ...
I am attempting to transform a table named app_user which has a column named created_dt into AppUser.CreatedDt in SubSonic3 using the ActiveRecord template. From what I've seen one should be able to modify table and column names as needed in the CleanUp method of Settings.ttinclude So I added this method to Settings.ttinclude string U...
Given the following: class Customer string name end class Order int number end I am creating a list of orders. For each order listed, i'd like to display the associated customer name. is there a way to do that via the object graph, or do I have to look it up manually? Chris ...
I have an issue when the Context.cs is generated. I have followed the SubSonic3 setup for ActiveRecord, http://www.subsonicproject.com/docs/Using%5FActiveRecord. I am using the AdeventureWorks sample database provided by MS. This is one of many lines having the issue: DataProvider.Schema.Tables.Add(new StoreTable(DataProvider)); This ...
If I run the Custom Tool on the tt templates with a linked app.config (from another project), then I get this error: Error 208 Running transformation: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0. at System.Data.Common.DbConnectionOptions.GetKeyValueP...
Hi there, I have a Website Project in my Visual Studio 2008. I added a Class Library so I can do my Subsonic Class Generation there and reference it via the project. However when I run the class generation it doesn't complete. It does almost nothing. I'll post what gets generated in the ActiveRecord.cs file. using System; using System....
I wish to make all my save transactions at the same time. I'm using Subsonic 3.0 with active record. I've seen some post with MyClassCollection.Save(); However when i "Run Custom tool" i don't get collections. Obviously i'm missing a trick here? There is of course another way to do this, using BatchQuery. I had an issue with this. App...
Hi, I made a class like: public class Video { public Guid VideoID { get; set; } public VideoCategory VideoCategory { get; set; } public int SortIndex { get; set; } public string Title { get; set; } public string Body { get; set; } public string Author { get; set; } public string Filename { get; set; } p...
Hi...I have some old code that was using Subsonic 1.x and want to migrate to 3. Some of my old methods used to return a Dataset using the old Subsonic Query object and then just calling ExecuteDataset(). I still need to support those methods, since they're called by other code...however, I can't find anywhere how to to a code query with...