This may be another of those "should be simple" things, but I can't find anything on it so here I am asking what will most likely be a stupid question :$ I'm using SubSonic 3 and I want to execute a query with a like clause but can't find that as an option. My straight SQL is like so: select * from table where column like %value% or co...
i want to make a webproject with Subsonic and Dynamic Data... But when i go register the ContextData a don't have it in subsonic with LINQ... in Global.asax.cs a have to do something like this model.RegisterContext(SubSonicRepo, new ContextConfiguration() { ScaffoldAllTables = true }); how can i make it work? have some way to make ...
Hi All, I am having problem with collection object. Here is the code CarCollection obj=new CarCollection(); obj.Where("Id","10"); obj.Load(); The problem is the result of the records doubles i.e actually there is only 1 record with the id 10 but it returns 2 same records. Please Help me as i am a newbie. Thanks ...
I'm using SubSonic 2.2. I am able to customize my class generation with templates like described here for example. However I would like to customize the Scaffold control also, but I have trouble figuring out how it is done. Editing the scaffold templates in the template directory seems to have no effect. If anyone has done this, any ...
Hi, Can you help me? I need to have subsonic.core.dll strongly named. How can I do this? Best Regards ...
I am currently using SubSonic (2.2 and 3) for some ASP.NET projects and have managed to get them working with SQL Server (using ActiveRecord). However, I also want to know how to set it up with other (open source) databases, e.g. PostgreSQL and SQLite. This is so I can use it on a web host without SQL Server on. The providers I have foun...
Hi to everyone, I'm reading a csv file and insert the information in a sql 2005 database. After about 250 object.save operations, it times out. here the code and the exact error message. this is not the first version of the code but it always give the same time out. This is not a big database, only 2 tables. Is there something I'm not...
Hi I am using subsonic 2.1, I have the object building, which has a subobject postalinformation. I want to load a list of building with also the object postalinformation for that building, in one database call. Is this possible in subsonic? If yes how can I do that? thx ...
I've got a SubSonic DAL - works great. Two classes: TblReceipt and TblReceiptLineItems. I can create a parallel class of TblReceipt, but seems like a waste, so here's what I need to do: Have a Class TblReceipt with one additional member, "ReceiptLineItems" - which is simply an ArrayList. This array list will be populated with TblRec...
Using SubSonic v2.x: The first issue is the error discussed here: Server Error in '/......' Application. Cannot serialize member '.....' of type System.Nullable I'm not sure where to place the code in my DAL from this post to get this working. I tried placing it in one of the partial classes I created for a table, but no go. Another ...
how to get the primary key value after the tablename.Save() method For Example: Table.Save(); here how to my auto generated primary key value... Thanks in advance Kishore ...
I have a class with a collection of other classes that gets serialized. The collection of classes is defined as such in my SubSonic partial class: public partial class TblReceipt { // no need to override any existing methods or properties as we // are simply adding // specifying the types of objects to be contained within...
Is there a way to query against a concatenated field using MS SQL? For instance, what I want to do is something like: Select FirstName+' '+LastName as FullName from Attendees where FullName like '%Joe Schmoe%' The above doesn't work. What I have found works is: Select * from Attendee where FirstName+' '+LastName like '%Joe Schmoe%' ...
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! What’s wrong here? This is how I found on examples of Subsonic 2 CodingHorror and doesn't works :( new CodingHorror().Execute("SELECT * FROM product WHERE IdProduct = @IdProduct", 1); The error I get is “Parameter '@IdProduct' must be defined” I’m using Subsonic 2.x and MySQL! Thank you for your help! :) ...
What is better? Use: GridView.DataSource = ObjectFromDB.All().Where(a => a.ID == null); Or: GridView.DataSource = ObjectFromDB.Find(a => a.ID == null); ? ...
I am using SubSonic version 2.2 to generate a script of my database using the /version command. Recently, I needed to generate a script for a database which is set to French collation and running on a French OS. The script fails because there are several columns which are of datatype "float" which use a comma instead of a period. (2,3 in...
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'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...