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 ...
I have a SQL Server 2008 database with a composite key: ProjectID (GUID) and TaskID (int). ProjectID is a foreign key to a Projects table. I want to have TaskID Auto-Increment, but restart for every ProjectID (that is: every projectID should have 1,2,3,... as TaskID). To my knowledge, this is not possible in SQL Server out of the box, a...
Hi I am having a problem with subsonic simplerepository. I have a users class and it has some optional fields.these optional fields are of type string. As soon as I try to persist my object , if the optional fields are null , an exception is being thrown I know string is already of type nullable so i cannot do something like nullab...
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...
Isn't this incorrect code generation? Shouldn't LoadAndCloseReader be used instead? #region PrimaryKey Methods public PublicationItemCollection PublicationItemRecords() { return new PublicationItemCollection().Where(PublicationItem.Columns.ItemID, ItemID).Load(); } ...
I have been looking and reading for an hour and i havent found a good tutorial for SubSonic. Do any of you have a recommendation? I am looking for a quick command line or winform tutorial (not a asp.net tutorial) to take in a class and create the table, insert a few elements and query them again. I'll get to the advance things later (j...
I am using the code below to update a second table (Info2) with the identity used from the first table (info2.Id = info.Id;). When the second save is carried out (info2.Save()) I get the error: "There is already an open DataReader associated with this Command which must be closed first.". Can anyone see what I may be doing wrong. SubSon...
I have a couple of question's regarding the following project. *Scott, Recently some developers have teamed-up to offer Oracle support (using Oracle's ODP.NET) for Subsonic 3.x, using the T4 Visual Studio template database provider system. Please search Github.com for Oracle/Subsonic, or my link, http://github.com/mabraham1...
I have started using Subsonic for a side project and have been loving using it. Simply a blast. I started off wanting to use the LINQ T4 Templates but have since switched to the ActiveRecord templates due to testability. It is very clear how to write unit tests using the active record templates but for the LINQ templates there is no clea...
Hi, I have a large table that must join to multiple Tables, I have a query with serveral condition that user may fill some of them. I used paged method of SqlQuery. Now, how can I get total record count? I want to implement paging on gridview and dont know how many records my query will retun? Thanks ...
I like the simplicity of the Simple Repository , this looks ideal for simple CRUD operations. However, if I have a requirement for a complex query on top and ideally want my app to call a Stored Proc what is the recommended way to do this? Does ActiveRecord cater for Stored Procs? I will be using this in a ASP.NET MVC app and really ...
I am getting started with SubSonic. I wanted to change my db to sqlite and i have this in my config file <connectionStrings> <add name="NorthwindSQLite" connectionString="Data Source=C:\unzipped\WindowsFormsApplication1\my.db" providerName="System.Data.SQLite"/> </connectionStrings> I get the exception A first...
Hey guys, I was wondering--what part of Subsonic 3 needs to be modified to support a different database under a Simple Repository scenario? I haven't found any documentation on this point. Subsonic 3 seems to be all about the T4 templates but when I check out the Subsonic project sources I don't see any T4 templates in there...so wher...
Hi Guys, I don't know if I am doing something wrong "I think I am" or I have hit a subsonic limitation. I have 3 tables Articles, ArticleCategories and ArticleComments with a one to many relationship between Articles the other tables. I have created the following class public partial class Article { private string _CategoryName; ...
I am using System.Data.SQLite with an sqlCommand String, this saves a Guid as expected. Using code I strange Characters save instead of Guid as follows: ù“•»I={E±gÒ §[, Code that seems to generate strange characters (as seen in SQLite Administrator): ... // Constructor in Class public ProfileUserAssignment() { ID =...
Hello, We developped our application with Subsonic 2 and c#. LazyLoading config has been set to false, all our application has been developped that way. But now we have run on memory problems when loading large collections and then serialize them (to send it back via web services). We can't enable lazy loading now as we would have to ed...
I have a basic object for saving to SQLite using SubSonic, the Save method is shown below... Adding and Updating the repository works, I then gave a Get Method that returns then gets the object back out the repository using its ID, however the ID at that point (on "this") has changed. Note: the ID type is a string representing a Guid. ...
Hi, I am trying to build a generic repository that wraps SubSonic. I have this code: Dictionary<Type, SubSonic.Repository.IRepository> repositories = new Dictionary<Type,SubSonic.Repository.IRepository>(); private IDataProvider dataProvider = ...; private SubSonic.Repository.IRepository getRepository<T>() { if (this.repositor...
Can I use the Subsonic on a console application? If so where should I have all the Web.config details like ConfigSections entry, Subsonicservice etc? Any help is highly appricated ...
I am using Subsonic (SimpleRepository) to query my SQL 2008 database. I am trying to write a query that will calculate the number of days between two fields and return records where the difference is less than a given number. However, I get a "The member 'Days' is not supported" error. Can anybody suggest an alternative query? Here's ...