Hi. I'm using subsonic 3.0.0.3 (active record) quite a simple database really, have trusted in its abilities but i am really getting let down by how incredibly slow it it to do anything. For some reason it likes to run through things more than once. For example: var newitem = new new_quote_item { quote_id = Convert.ToInt32(newQuoteI...
Is there an oracle ttinclude file available anywhere? ...
Hi All, Before ask my question, i have to say that subsonic is wonderfull tool, i realy like it. I have an application which is createg domain layer during the runtime itself. I mean It has got customizable entites and when the entity added or any entity schema changed my model layer compiled again in the runtime according to changed dat...
I need to insert a record to a table. Subsonic builds the query something like this (as far as i know): INSERT INTO Table1 (Title, Description, RowVersion) VALUES (@Title, @Description, @RowVersion) But i want to remove the RowVersion column from the SQL query bacause its autogenerated by the sql server. How can i do that? ...
I'm attempting to write a linq query which uses several tables of related data and have gotten stuck. The expected result: I need to return the three most populous metropolitan areas per region by population descending. tables w/sample data: MetroAreas -- ID, Name 2, Greater New York Cities -- ID, Name, StateID 1293912, New York City...
I have to get up to speed with subsonic 2.* to support an existing application. The subsonicproject website has a few walk-throughs but I was hoping to find something more complete. For instance, I don't see any mention of how to create a new record using subsonic. Thank you, Myron ...
Using the latest version of Subsonic (3.0.3) it doesnt appear to me that the geometry or geography data types are implemented as of October 09. My questions are: if and when is this support likely to be added? does anyone have a workaround to support operations on simple geography types at the DAL level? All I really care about at ...
I am using SubSonic 3.0.0.3 in SimpleRepository mode. I was wondering how to get Subsonic 3 to automatically create and populate the createdon, createdby etc audit fields that were standard in version 2.x . Is this something I have to configure with the T4 templates? ...
I have a clumsy way to get the max length of a column in the database, but it's so bad that it seems wrong: var length = new DataNS.WidgetTable(provider).description.MaxLength Do I really have to instantiate some object and go digging through it? I even have to pass a provider to it explicitly. If this really is the right way to do i...
I'm a bit confused on where to find the most up-to-date copy of SubSonic 2.x, after following the links I think it's here: http://github.com/subsonic/SubSonic-2.0 on GitHub, but I don't see anything showing it's 2.2+ versus something lower like 2.0 or 2.1. Can somebody confirm that GitHub has the most up-to-date version of SubSonic 2.x,...
Hi there, I'm was going to update are windows VB.net project to use Subsonic 2.2.1 from 2.0.3.0 I was testing 2.2.1 to make sure everything would update with no problems and guess What I have most for the data grid views bind to the subsonic generated collection and I can change the columns header text, I found with the test that I c...
I'd like to perform an left join in this query.The query like: select ... from tableA left join tableB on tableA.Cola=tableB.Colb and tableB.Colc='some value' I want to know how to perform the "and" condition,i try to coding like: new SubSonic.Select().From("tableA").LeftOuterJoin ("tableB","Colb","tableA","Cola").AndExpression("Colc...
There seems to be a Bug with the Outer Join statement in SubSonic 3, or maybe it's just my ignorance, but the following craps out: var Objeto = from t in Table1.All() join su in table2.All() on t.Id equals su.Id join tab2 in Table1.All() on t.PId equals tab2.Id into gj from j in gj.DefaultIfEmpty()...
I've been exploring Sub Sonic 3's SimpleRepository and have been pretty happy with it but have a question regarding transactions. I am aware that using methods like 'AddMany' and 'DeleteMany' will automatically perform all of those operations within a single transaction, but was wondering if it's possible to force the SimpleRepository to...
I have the following code using SubSonic 2.1/2.2 SubSonic.Update(<some table>) .Set(<column A>) .EqualTo(<column B>). Where(condition...).Execute() I would like to change it to update "column A" with the value of "column B" + 1. How can I do it with this syntax. Is there a better SubSonic syntax to achieve the same thing: ColumnA = ...
My problem is about the timestamp column in one of my database tables. This field is required because sqlserver automatically generates it. Since this column is required subsonic included it in the insert query.. im using subsonic 3.0 info.Save(); error message: Cannot insert an explicit value into a timestamp column. Use INSERT w...
I've just started using SubSonic 3 and I'm using the ActiveRecord T4 template. If I make a change in the database (add a column to a table for example), what is the correct method for forcing the code produced by the T4 templates to be re-generated? At the moment I'm just deleting the ActiveRecord folder in my project then dragging the...
I am trying to add a boolean column in SubSonic 3.0.0.3 and without this column the code works fine but as soon as I had a bool variable into my model this fails with the following error: The name "False" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column nam...
Hi, I am using SubSonic on a project with many tables which were created by a sourcecode generator. I noticed Some classes created by SubSonic were generated without code and have the folowing message The class...was not generated because ... does not have a primary key. Is there any way for me to get the code to be generated without ...
Hi I'm writing a proof of concept and when using InlineQuery() or CodingHorror() I get an error stating my target table is an invalid object. However, if I use Query() using the same SQL Select statement and connection string, I get results as expected. Here's the code: string sql = @"SELECT * FROM PER_ALL_PEOPLE_F WHERE ROWNUM <= 10"...