Subsonic 3 : get only certain columns

Posted by CTGA on Stack Overflow See other posts from Stack Overflow or by CTGA
Published on 2010-04-28T00:50:30Z Indexed on 2010/04/28 0:53 UTC
Read the original article Hit count: 278

Filed under:

subsonic3

|

serialization

|

json.net

|

query

Hello,

I use : Subsonic 3, SQL Server 2008, Json.Net

Here is my problem :

I have a house table with id,lot number, address, location, ownerid and an owner table with id,name, description.

I'd like to get only the owner name and address of house where location is "San Francisco".

How can I do this with Subsonic?

My problem is I can only get a typed list or a datareader, I don't understand how to only get an array or a simple list.

What is the best solution? Create a custom class ? Create a View ? Anything else ?

My aim is to then serialize the data to send it back to my application, but serialization is seriously long because of the numerous relationships (My example here is simplified, there are indeed : house - owner - city - country etc.), whereas I need only 2 fields...

Thank you

© Stack Overflow or respective owner

Related posts about subsonic3

How to log subsonic3 sql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm starting to develop a new asp.net application based on subsonic3 (for queries) and log4net (for logs) and would like to know how to interface subsonic3 with log4net so that log4net logs the underlying sql used by subsonic. This is what I have so far: public static IEnumerable<arma_ocorrencium>… >>> More
Left Join in Subsonic3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName… >>> More
Help with Subsonic3 ActiveRecord LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ (subsonic) SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Help with Subsonic3 LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Using constructor to load data in subsonic3?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor. The constructor is: public Document(Expression<Func<Document,bool>> expression); and i try to load a single item in like this var x = new Document(f=>f.publicationnumber=="xxx"); publicationnumber isn't… >>> More

Related posts about serialization

XML Serialization and Soap Serialization

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I think even if we will not need interoperability between applications, and even we do not communicate with web services, it is easier to serialize using SoapFormatter than XmlSerializer because SOAP will serialize the private members by default, while XmlSerializer will work on public properties… >>> More
Binary serialization/de-serialization in C++ and C#

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. I am working on a distributed application which has two components. One is written in standard C++ (not managed C++) and the other one is written in C#. Both are communicating via a message bus. I have a situation in which I need to pass objects from C++ to C# application and for this I need… >>> More
Insert some data at later point once serialization(binary serialization) is done for a class

as seen on Stack Overflow - Search for 'Stack Overflow'
My application is written in C# and I am a newbie to C#. I am facing with a problem during serialization. The problem is as follows. There are many classes in my project and when serialization is called on one of the main class object it serializes itself and during this process many of the member… >>> More
FormatException with IsolatedStorageSettings

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem when serializing a Dictionary<string,Person> to IsolatedStorageSettings. I'm doing the following: public Dictionary<string, Person> Names = new Dictionary<string, Person>(); if (!IsolatedStorageSettings.ApplicationSettings.Contains("Names")) { … >>> More
Serialization of Queue type- Serialization not working; C#

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Consider this piece of code: private Queue Date=new Queue(); //other declarations public DateTime _Date { get { return (DateTime)Date.Peek();} set { Date.Enqueue(value); } } //other properties and stuff.... public void UpdatePosition(...) { //other code … >>> More