Hi, I'm using Subsonic 3.0 on a Web application that has fairly simple databse demands, so I've opted to use the SimpleRepository approach. Ideally I wanted to encapsulate functionality as much as possible instead of creating SimpleRepository objects within business objects as and when they're required. So I came up with the following a...
Howdy - With QuickTable, is there a way to pass multiple parameters to the link column. For example in a gridView. If I want to have two parameters in a linkable column, I set two params in DataNavigateUrlFields="*client_id,io_id*". The params are separated by commas Then I set DataNavigateUrlFormatString="Default.aspx?client_id={0}...
If you are using Subsonic 3.0 and plan to use the SimpleRepository and POCOs... How do you specify how to map from a POCO to a database table? Thank you ...
Question: How do I preserve "dirtiness" of SubSonic objects when they are sent back and forth across a Windows Communication Foundation service? To wit: I have a WCF service call that returns a collection of SubSonic (2.2) objects, like so: // WCF server side public MyObjectCollection GetAllMyObjects() { // Retrieve a MyObjectColle...
Am using SS 2.2 and am running into issues with a listview and implementing paging / sorting etc. Can't work with SS3 anyone know if I'm asking for trouble by having both in the one project? ...
Say I have a forum system with Threads, Posts and Tags. The structure is the same as StackOverflow: Threads have a 1-many relationship to Posts, and Tags have a many-many relationship to Threads. The (simplified) tables: Thread ------ ThreadID int PK Title varchar(200) Tag ---- TagID int PK Name varchar(50) ThreadTag ----------- T...
I think i am hitting a limit. I have two IN statements in the SQL generated by subsonic. Or am I hitting the varchar ( 8000 ) limit? When I send i fewer parameters, the statement returns results, when I send in more, the result set comes back blank. Below is what I am catching in SQL Profiler: exec sp_executesql N'/* GetDataSet() */ ...
Hi, I have a table which has a two fields, userid and degreeid. A user can have multiple degreeds in this table. When a user select their degree I want to delete any degree id already in the database but un-selected by user. How should do it? I try to use something like this with no luck. repo.DeleteMany(x=>x.MeetingAttendeeUserID==user...
Hi, does Subsonic use optimistic concurrency in some way? Thx ...
i've inherited a project that is using subsonic. I wish to extend the OrderItem class with a new property "ProductType". I am able to add the following. But as this a sub directory of /generated/ i'm obviously feeling like i'm missing a trick here. Do i need some kind of BAT file. [XmlAttribute("ProductType")] public string Prod...
I am Unit Testing with Subsonic 3.0.0.3. Unit tests ran as expected with record count assertions passing. However the testing framework does not auto increment identity columns. For example var p1 = new Person() { Name = "Jack" }; p1.Add(); var p2 = new Person() { Name = "Jill" }; p2..Add(); var t1 = Person.SingleOrDefault(p => p.Nam...
Hi I'm using GoDaddy Deluxe Plan Hosting and SubSonic 3.0. I have problem with Security Exception. I searched the net and found several older solutions, like this one: http://ozzieperez.net/blog/?p=9 (this one is from 2 years ago) I tried this and I still could not manage to make it working... Can someone please confirm that SubSonic...
Hello - Can anyone point me to a doc on how to get Subsonic's 2.2 scaffolding working in MVC 1. Or, does Subsonic's 2.2 scaffolding even work in MVC 1? Love this software btw...Thanks Rob and others. ...
I'm getting very odd errors when compiling our Data Access library (all subsonic). Errors are Error 35 The type name 'Web' does not exist in the type 'S3.DACL.System' C:\Projects\S3\src\DACL\AspnetUser.cs 369 63 DACL And Error 37 The type name 'ComponentModel' does not exist in the type 'S3.DACL.System' C:\Projects\S3...
I've got a Subsonic query that isn't returning any values. I think the problem is in my where clause, although I'm not sure why. What I'm really looking for is a way to debug the query to see the SQL that's actually being spit out by Subsonic. I know there was a way to do this with the Query object with Inspect(), but I'm using Select...
I'm trying to do a Subsonic Query with an IN statement containing multiple strings. If I manually hard-code the strings, it works fine. Example: Dim qry As New [Select]("mySelectColumn") qry.From(table.Schema) qry.Where(table.Columns.mycolumn).In("string1", "string2", "string3") Hoever, I need to be able to pull the IN statement str...
How I can add undo functionality with SubSonic.. thanks in advance ...
I'd like to use Subsonic in a shopping cart application, but I'm trying to replace code that is using Session to store an Order object. That Order object has a collection or OrderDetail objects that are added to the collection through the shopping cart process. I'm impressed with what Subsonic can do and I think I'm missing how I could...
I've got two main sprocs that I'd like to link up to two separate object data sources. I generate my DAL in a separate project, and simply import the DLL into my current project. The problem is that I'm unable to see any of my DAL objects in the business object dropdown list, and none show up when I select Show Only Data Components. I...
I watched the http://www.subsonicproject.com/docs/Using%5FSimpleRepository screencast, but I am left wondering... how do you migrate existing data? Assume you decided to split a Name property into a FirstName and LastName. How do you do this in Subsonic? ...