-
Thanks. I've since resolved the issue I was having with database update. I haven't had the issue you explain. My Dropdowns are populated with collections. I manually configure the Column on the grids, but if I don't, the table columns are used. I'm binding to a BindingSource which is...
-
Hi there, I recently came across a bug when using DB.SelectAllColumnsFrom() With the following query: string r = DB.SelectAllColumnsFrom<Competition>() .From(Competition.Schema) .InnerJoin(UserCompetition.Schema) .Where(UserCompetition.Columns.UserCompetitionID).IsEqualTo(userCompetitionID) .BuildSqlStatement...
-
Hi Guys, I've been using the scaffold control and have come across the following problem: I have 2 tables setup both contain ProductID as primary key ProductionInformation ProductID PK Description Company ProductLatestPrices ProductID PK FK CurrentPrice Qty Basically I have 2 tables that map 1 to...
-
Hi there, Update: I think my problem has to do with a database table that I have which has composite keys. I just tried using the scaffold control in 2.1 latest svn, I found that for many tables in my database this works fine, but for one particular table I have a GUID as foreign key and I noticed that...
-
Hi there, In the svn builds I noticed a new overload method for Select() constructor for safe column names: http://code.google.com/p/subsonicproject/source/detail?r=422 Added overload to the Select() constructor to take typed columns for safe column names. For example, you can use this query: "Select...
-
Hi Guys, Question 1) I was reading this page: http://subsonicproject.com/2-1-pakala/subsonic-2-1-beta-is-up/ and I noticed it said: We now support partial object loading - you don’t need to load the entire object if you don’t want to. I was wondering what it means and how is it implemented? Is it a config...
-
Hi there, I was wondering if someone could help me with the following problem regarding inner join and a column with a space. I have setup a test product such as: class TestProduct { private int _id; public int ProductID { get { return _id; } set { _id = value ; } } private string _name; public string...
-
Question was answered here: http://forums.subsonicproject.com/forums/p/2700/11443.aspx#11443 I don't know how to delete posts sorry guys Regards DotnetShadow
-
Hi there, I've been using the repository pattern and I was wondering what the return value of DB.Save() should be when you have joining table such as: Customer (PK id) - CustomerOrder (customerID, orderID) - Orders (PK id) If I have the following: CustomerOrder co = new CustomerOrder; co.customerID...
-
Hi there, Just wondering when using the Repository pattern how can we inspect the sql that is being executed? i.e DB.Save(product) =>> INSERT INTO ...... Regards Dotnetshadow