tags:

views:

89

answers:

1
Q: 

SubSonic 3 - CRUD and Inner Join Queries - Help for a Stupid Programmer.

Please somebody help doing the oldest things on SubSonic.. like CRUD.

Please tell how can i do an INNER JOIN / LEFT JOIN relationship queries.

thank you very mucg.

A: 

http://stackoverflow.com/questions/1290539/subsonic-3-innerjoin

Hope that helps.

Pino  2009-11-05 12:24:50
thank you ! in this case... var fileIdsAndTypeds = from files in filesTable.All() join types in filesTypes.All() on types.filetype_idColumn equals files.filetypeColumn select files;if i need to return the description of the filetypes table, how can it be done ?thanks.
Rafael  2009-11-05 16:23:23
can you post in your main post so i can see the formatting?
Pino  2009-11-06 09:09:36

related questions

Subsonic 3 Active Record Testing
Is there any demo to insert a new record into a table with identity primary key using Subsonic 3?
Subsonic SimpleRepository problem with Category.All
Problem with RunMigrations in SimpleRepository Example - Subsonic 3
Subsonic 3, MySQL T4 template: Structs.tt fails
SubSonic 3 ActiveRecord generated code with warnings
subsonic 3 scaffolding
Subsonic 3.0 SP parameter error
SQL Views in SubSonic 3.0
Defining SubSonic 3 ActiveRecord migrations
Is my IQueryable syntax correct?
Subsonic 3 Union Possible?
Create Foreign Key to ASP.Net Roles table
Does Subsonic 3 ActiveRecord Handle Many To Many Relationships?
Is there a way to generically return all of the records from a table with the Entity Framework
Is Subsonic 3.0 safe for production use?
Subsonic 3 SVN Checkout and T4
Subsonic 3/ASP.net MVC issue trying to override class column properties
NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?
Subsonic 3/ASP.net mvc trying to save a null value in a datetime column
Which SubSonic 3 template to use
Subsonic 3 State
Subsonic3 & GUIDs
Subsonic 3 - Namespace hidden - Probably me!
Inserting a new record pattern in SubSonic 3