Subsonic 2.2 is throwing the error subsonic Invalid cast from System.Int32 to System.Byte[] When I do the following
I\'m getting locking exceptions when trying to use transactions with SubSonic and SQLite. I\'m using this from a single thread and there are no other processes accessing my db, so I really didn\'t exp
New to SubSonic, inherited it with a project that uses SubSonic 2.2.1 I have tried to added a column to one of my tables and run the tool to update the classes, The table n开发者_如何学Came is Feedba
I have 2 tables in my DB, Customers, Contacts. CusID is a Foreig开发者_JS百科n Key in Contacts table. I tried the following
I currently developed an app that connects to SQL Server 200开发者_Python百科5 database, so my DAL objects where generated using information from that DB.
I\'m wondering if the following SQL update query is possible using the equivalent SubSonic commands: UPDATE MYTABLE SET MYFIELD = MYFIELD + 3 WHERE ANOTHERFIELD = ANOTHERVALUE
I\'ve got a question regarding how to retrieve the auto-increment or identity value for a column in SQL Server 2005, when said column is not开发者_C百科 the first declared column in a table.
How would you best handle constructing this SQL statement in SubSonic? SELECT ac.* , SUM(pt.amount) AS 开发者_如何转开发totalPoints
I am using Subsonic 2.1 and I need to doan innerjoin and use a where expression and I keep getting the error:
Hey All! I\'m trying to construct a query that is something like this: Where column = \"value\" AND column2 = \"value\" AND (column3 = \"value\" OR column4 = \"value\")