Had a system with v2 running well. Swapped out the Visual Studio reference for the v2 DLL to the v3 DLL. Rebuilt the project. Errors. I used to have things called "MyYahooCollection", now I only have "MyYahoo" and "MyYahooTable". The collections seem to be gone. What did I miss? I am using SQL Server 2005 on the back-end and am imple...
I'm getting my head back into SubSonic on a project with v2.1 fairly embedded (meaning we won't be switching it to v3). I'm ripping through a bunch of method parameters to build a long, but not overly complex, query. At the tail end of this query, I need to add a statement that adds a group of OR statements, something to the equivalent...
In the Repository there is a GetPagedList method. I have a method that expects a return of PagedList I currently have return _repository.GetPaged(sortBy, pageNumber, 20); However I now need to do some checking such as _repository.GetPaged(sortBy, pageNumber, 20).Where(x => x.IsAdmin == false) This now changes type to IEnumera...
Hello all, Is this at all possible ? If it is possible could someone ilustrate a very simple example? I can't create a many to many relationship. Thank you ...
I got a Model, with a property of type byte[], with corresponding field equivalent on sql server of type varbinary(128). saving went well. but the problem is my password field is always NULL. guser.Password = Encoding.ASCII.GetBytes("sample"); repo.Add(guser); Is this a bug or a user bug? ...
When running the templates against a database with 1400+ tables I get the following error. The server shows hundreds of connections. Does anyone know if this is a problem with template generation in general, or with these templates specifically. Other, smaller DBs generate ok for me. Running transformation: System.InvalidOperationExce...
I have a legacy database that has column names like "void". I also have several Microsoft SSIS log databases. those have column names like "event" and "operator". It looks like we need to set the CleanName on the column early on in Settings.ttinclude template, but I am not quite sure the best way to tackle this since the list of reserv...
On a bit of a learning curve. Know one of you gurus can help me out. I'm looking into SubSonic (SimpleRepository) and StructureMap. Really trying to get my head around them both. I want to use SimpleRepository for the ease of use and letting my models define the database rather than pull off of or create a DB structure initially. I ...
I'm working with Subsonic's SimpleRepository, and I'm trying to write some unit tests so they don't touch the database, but I'm having trouble figuring out if SimpleRepository can work against in-memory lists (Like the active record can) instead of an actual database. I would like to do the following: //setup test data var repo=new Sim...
Hi, I want to know that How to Insert New Columns to an existing database Table using Subsonic 3.0.0.5 MIGRATIONS. Basically I want to alter an existing table in MS SqlServer database and add three more columns into it. Please tell me How I will be able to do it Regards, Naveed Khan ...
Hi, I want to update a table row and I have a following Code void updatePrimaryPaymentAndSecondaryPaymentSourceTypes() { LookUpDetails lookUpDetail = new LookUpDetails(); var repo = new SimpleRepository("E2Lending", SimpleRepositoryOptions.RunMigrations); lookUpDetail = repo.Single(80); lookUpDetail.Col1Value = "My Checking Account...
I would like to add basic logging and make some other minor changes to the classes generated by SubSonic 2.1 (I'm not using SubSonic 3.0 t4 templates). Is there a way to do this without modifying the SubSonic source code? ...
Hi, I'd like to add a query to my SubSonic DAL that uses the MySQL fulltext search construct "WHERE MATCH (columnlist) AGAINST (searchterm)", but can't find an equivalent in SubSonic. Is there a way of using Subsonic to execute a "literal" query - i.e. it just queries with the exact MySQl code I feed it? Alternatively, could I impleme...
Is it possible to use subsonic for complex objects. Example (not all details but sample properties) public class Order{ public int OrderNum {get;} public Customer Customer {get;} public IEnumerable<OrderLine> OrderLines {get;} } ...
Hi, I am having a problem with saving of data because of an incorrectly generated parameter name. The table has a field "E-mail", and when the class wrapper is generated, the InsertCmd uses "@E-mail" as one of the parameters. In SQL Server, this is illegal and generated an exception. I have hunted all over SubSonic for a way to modify...
I'm trying to start using Subsonic (v3). The brief installation instructions indicate that I must: add a reference to the DLL = Done edit Setting.ttinclude to use right connection string = Done; added appsettings to web.config add templates to project = Done, but nothing is generated; no errors and no code. The demo indicates that wh...
I am trying to use the query tool, but I can't figure out how to specify the correct paremeter for the join. This is as far as I get: List<Tran> = new Select().From("Trans").LeftOuterJoin( according to intellisense, parameters of type SubSonic.Schema.IColumn are expected next. How do I supply the correct parameters? ...
I need to add Formula property/field on SubSonic | SimpleRepository Can someone tell me how to? or is it not possible? br, No Body ...
It doesn't appear so from the online docs, but I wanted to ask the question here anyway......Will Subsonic 3.0 support DB2? Specifically......I'm working on an enterprise app that needs to connect to DB2 on MVS. ...
Hi, on the configuration there's a way to set the tables we want to exclude but what I need is to set the name of the table I want to include, excluding everything else. Have anyone already done this? Cheers! Alex ...