Browse by Tags

Scaffold Control [BUG]: 1 to 1 Relationship Problem can't edit?

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 05-12-2008
Scaffold Control: Operand type clash: uniqueidentifier is incompatible with int (SOLVED)

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 05-11-2008
New select() for safe column names DB.Select() vs new Select()?

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 04-22-2008
What is 'partial object loading' and how do you use 'Migrations'?

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-31-2008
How can this be done? Spaces in db columns mapping to ExecuteTypedList

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-27-2008
Joining tables - Column with spaces problem

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

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-27-2008
Repository Pattern - DB.Save() return value

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...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-25-2008
Repository Pattern and Inspect() how to get sql executed?

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

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-21-2008
[Fixed] - Mbunit - There is already an open DataReader associated with this Command which must be closed first

EDIT: I found the solution to this problem http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=213744&SiteID=1 Turns out I have to use this: Multiple Active ResultSets (MARS) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/MARSinSQL05.asp Basically in my connectionstring...

Posted to Version 2.1 - Pakala (Forum) by robsworld2006 on 03-18-2008
Subsonic Noob question - Active Record generation

How do I kick off the generation of the Active Record code? When I run "sonic.exe generate /out Generated" I get the base classes and the controller classes for the tables in my db, but nothing else. I am using the default templates for Subsonic. My app.conf options are: <SubSonicService...

Posted to Version 2.1 - Pakala (Forum) by asmorger on 03-01-2008

Page 1 of 2 (11 items) 1 2 Next >