-
The other problem I wrote about here http://forums.subsonicproject.com/forums/p/3208/14846.aspx#14846
-
I think I may have found the cause of the error. It appears to be two fold. First if you look at the OracleDataProvider Line 244 you will see that the Automatic Connection is getting Disposed and so the reader is getting Closed. I changed the OracleDataProvider to look like the SqlDataProvider replacing...
-
I think I may have found the problem. I was getting the exact same Error in Oracle. The following Code PersonCollection pc = new PersonCollection ().Where( "First_Name" , "bret" ).Load(); would give me the error as it generated the Following SQL SELECT PERSON.PERSON_ID, PERSON.FIRST_NAME...
-
I have some code that works with 2.0.3 but does not work with 2.1.0 example: Dim cd as string = "code" Dim exampleCollection= New EXAMPLE.ExampleCollection() exampleCollection.Where("COL1", SubSonic.Comparison.NotEquals, cd).Where("COL2", cd).Load() System.Console.WriteLine...
-
Hi! I have multible Oracle clients installed on my machine: Driver={Oracle in 92} and Driver={Oracle in XE}. When I use SubSonic I want to read and write data to {Oracle in 92}, however, because I installed Oracle Express the default instance is now {Oracle in XE}. This causes the following error in...
-
Hi, i was wondering if it wasn't good idea to replace: private const string TABLE_COLUMN_SQL = "SELECT user, a.table_name, a.column_name, a.column_id, a.data_default, " + " a.nullable, a.data_type, a.char_length, a.data_precision, a.data_scale " + " FROM user_tab_columns...
-
Hi, I've decided to post this information because It may be relevant to others and because I think SubSonic is very usefull. I was working in a simple project involving an Oracle database but the production database was version 8.1.7 and in our development environment we were working in a 10g version...
-
There was a post about it here . I'd like to clarify this issue. I looked up the source code of OracleDataProvider class. There is method GetTableSchema that generates a metadata for each table. Actually, there no code related to any relations of the table! It just load columns and indexes. If you...
-
Hi everyone,
I have created a DB in MS SQL which has bit columns in most tables. These are nicely translated to boolean properties in SubSonic entities. Now I have to also create the same DB in Oracle.
My question is, what do you guys use in Oracle to represent boolean/bit columns?
Many thanks...
-
I wamt to generate a class object for just 1 database object which happens to be a view. A PK should not be preventing this from working. When I run SubCommander, nothing is generated. <connectionStrings> <add name="AppConnection" providerName="System.Data.OracleClient" connectionString...