Subsonic 2.2 InnerJoin Across Two Databases

multiple-databasessubsonicsubsonic2.2

Can anyone provide an example of how to join across two schemas using subsonic 2.2.

This doesn't work:

SqlQuery qu = new Select("*")
.From(NorthwindLeads.Lead.Schema)
.InnerJoin(Northwind.StatsMap.SourceIdColumn, NorthwindLeads.Lead.SourceIdColumn);

Best Answer

There's no easy way to do this in subsonic that I'm aware of. I would recommend adding a view to your database which returns the data you want from the other schema and then joining to the view in your subsonic query.

Related Solutions

SubSonic “Or” and “AND”

var query = DB.Select().From<Table1>()
                       .InnerJoin<Table2>()
                       // Where() takes a ColumnSchema type
                       .Where(Table1.FieldXColumn).IsEqualTo(1)
                       // AndExpression only takes strings, so use the column struct
                       .AndExpression(Table1.Columns.FieldY).IsEqualTo("S")
                       .Or(Table1.FieldYColumn).IsEqualTo("T")
                       .ExecuteAsCollection();

Update a column value based on another column value with SubSonic 2.1/2.2

Using SetExpression instead of Set will solve the problem

SubSonic.Update(<some table>)
.SetExpression("columnA")
.EqualTo("columnB + 1").
Where(condition...).Execute()

Best Answer

Related Solutions

SubSonic “Or” and “AND”

Update a column value based on another column value with SubSonic 2.1/2.2

Related Topic