hi folks i have build everything in order to create a model from 2 models so that i can create a view for the single model. one table holds info for 1 quote and the second table holds a list of items within that quote. the error i get is: The model item passed into the dictionary is of type 'graniteConcepts.Controllers.QuoteViewModel'...
When I add a web deployment project and compile a site, the files are created in the proper deployment location. However, I get an error when I visit the website: Signature of the body and declaration in a method implementation do not match. Type: 'MySite.SS.TableName'. Assembly: 'example.com, Version=0.0.0.0, Culture=neutr...
IS there a actionpack/subsonic generator for 3.0 like there was for 2.0? ...
Is it possible to do a join to a nested select statement in SubSonic 2.2? I am having trouble with this because I have to do a group by... I.E. select conn_company.company_name, SUM(t.quote_grand_total) as 'SUM' from conn_company inner join (SELECT * FROM [dbo].[QuoteDBAll] where [dbo].[QuoteDBAll].[quote_status_id...
I'm using AcriveRecord in SubSonic 3.0.0.3 with MySql. Is there some easy way to perform something like "SELECT CustomerAddress FROM customers" rather than .All() which performs "SELECT * FROM customers"? And how to get distinct values? ...
I'm using Subsonic 2, SQL Server 2005. Here is how I update intro_accepted column of a Member table record. member.Showintro = true; member.IntroAcceptby = AdminUser.Username; member.IntroAccepted = DateTime.Now; // but I wan't getdate() from SQL Server member.Save(); What is the easiest way to select getdate() from database and put ...
hi there, im using subsonic 3.0.0.3 activerecord and everything is fine and i get no error but when i update a database, it never seems to actually happen, can anyone spot anything i am missing here?! ta code: var myquote = createNewQuote(); var gross = 36.00; myquote.totalcost = gross; // set the new value in my model UpdateModel...
SimpleRep looks great. How do can I write advanced migrations that tell the Repository that a variable name has been renamed? It´s DB-Field-Representation (or better it´s values) should not be dropped and a new column with the new name created. Instead it should rename the column. Couldn´t find that in the SimpleRep page nor in the shor...
After running "Run Custom Tool" on the .tt dropped on my VS2k8 prj I'm not able to run my program.. shows 8 errors like: Error 23 The type 'SouthWind.LanguageText' already contains a definition for 'KeyName' C:\Documents and Settings\Administrador\Meus documentos\Visual Studio 2008\Projects\WindowsFormsApplication4\WindowsFormsApplica...
I have an issue when the T4 linq templates generate the classes for my MySql db using subsonic 3. It looks like one of our table names "operator" is causing problems in the Context.cs generated class. In the following line of code in Context.cs Visual Studio sees <operator> as a c# operator and generates a compilation error of "Type exp...
Using SubSonic 3 ActiveRecord, I generated code from an existing database that had foreign keys. To ensure database schema is always correct when switching databases, I placed migration code at the beginning of the app, using IDataProvider.MigrateToDatabase<MyClass>() for each class generated by ActiveRecord.tt. Turns out, migration code...
I'm building a site that runs fine for a few hours, but then *.asmx and *.ashx calls start timing out. The exception is: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool This may have occurred because all pooled connections were in use and max pool size was reached." I'm using SubSonic as the ...
I'm fairly new to SubSonic, and downloaded the latest version which only contained a zip file with the folders Binaries, Examples and T4 Templates. Upon further reading I was looking forward to trying the Scaffolding control, however the DLL contains no tools to add to the VS2008 toolbox. I'm also unable to use .Fetch, .FetchByID, etc....
All the sudden I cannot get Subsonic to generate new class files off my database, and I can't find anyone with the same problem. Take a look at the Command, Web.Config and Output Error below to see if you can help. Thanks. Command C:\Documents and Settings\My Documents\SubSonic2.2_2\SubSonic2.2\SubCommander\sonic.exe generate /out DA...
Hi All, my first question here on Stackoverflow (wish me luck :)) So, I have a new site on my mind that I would like to create using as much "generation"-friendly stuff as possible due to the fact that I'm getting tired of coding the same stuff all over again. This has made me take a peek at the SubSonic project (have been looking at t...
Hi using Subsonic 3.0.0.3 it appears there is some issue with Subsonic identifying Stored Procedure paramters as output parameters. In the StoredProcedures.cs class I find my stored procedure definition but the last parameter is defined incorrectly as a 'AddParameter'. sp.Command.AddParameter("HasPermission",HasPermission,DbType.Boole...
How do you create binary columns in the DB using SubSonic's Schema builder? So tonight I decided to dive into SubSonic. I see a lot of questions on here and great responses by Rob and many others. I see that SubSonic is an ORM, with the T4 Templates it can generate some very nice and efficient classes from an existing database. But, I...
How do i get the identity. The following code enters a value into orderItem. I wish to return orderItemId. public static StoredProcedure StoreAddToCartSAS(string userName, SAS.Business.Domain.Product product) { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Store_AddItemToCart", DataService.GetInstance("dash...
It seems to cause a conversion error: can't convert int16 to int32 ...
I have an old implementation of the Commerce Starter Kit using Subsonic 1.xxx. A while ago my client upgraded to sql server 2008 and BOOM!, subsonic can't access it. Question(s): Does the old subsonic source code exist somewhere? Is there anyone who had the same problem and started using Subsonic 2 instead? What's the easiest way to m...