-
A project I'm currently working on has just switched from int IDENTITY to Guids for their primary keys, populated by newsequentialid(). I've regenerated the DAL, and am now in a position where new items committed to the db are generating guids correctly in the table, but aren't populating...
-
Hi there, I'm attempting to use the repository pattern with a new project, and I'm looking for an efficent way of populating two distinct objects from a single view. The two objects are related, and one sits as a property of the other. I've got no problem manually binding them, but it's...
-
Hi I am porting an app written with the ActiveRecord pattern to Repository pattern (Pakala 2.1). The old app used, for example, Order.GetUpdateCommand()... to generate a QueryCommand that can be used in Transactions. however, with the Repository, I cannot seem to find a way to do this. Once I made changes...
-
Hello, "VClient" is a View. Here's the error when running this code: dal.VClient c = DB.Get<dal.VClient>(clientID); "The type 'dal.VClient' cannot be used as type parameter 'T' in the generic type or method 'dal.DB.Get<T>(object)'. There is no implicit...
-
Hi Not sure where and how to post this suggestion for some methods in the repository pattern (ISubSonicRepository interface) I have the latest build and made a patch as a suggestion, but where to upload it? I needed a SaveAll on the collections like the ActiveRecord have and since i couldn't find...
-
Hello! I think I found a bug in the repository insert when not using autoincrement-pk. The query will never execute unless its autoincrement. My fix was just to move the ExecuteScalar-statement to make sure its run. I dont know if its the correct way though! Index: SubSonicRepository.cs ============...
-
Thanks for getting back to me. I had tried updating and recompiling yesterday afternoon, following your line of logic. Here's what I saw: There was no change, however, even when not using the repository pattern, the query command still lacked any population of the SET section of the SQL query. No...
-
I'm working with Pakala 2.1.3 and have hit an error. When using the DB.Save(RepObj) function an exception is thrown (Incorrect syntax near the keyword 'WHERE'.). Drilling into the exception, I found this information which may help. _commandText = "UPDATE [dbo].[ControlParms] SET WHERE...
-
Here's what I did ... who knows if it's efficient. After working on it all afternoon, I'm glad it works: Select the list to be excluded convert the collection to an array of objects pass the array to the new collection selection as an array attached to the NotIN. You may have to stumble through...
-
Hi, When using the RepositoryRecord templates it is not possible to insert a new record and then update a field: RecordType r = new RecordType(); r.Field1 = "val1"; r.Field2 = "val2"; DB.Save(r); r.Field2 = "new val 2"; DB.Save(r): // This will not update Field2 in the database...