SubSonic 2.2 Projections

subsonic

How do you fashion projections in SubSonic 2.2? Basically I wish to return columns from two tables that are joined.

Best Answer

My personal preference for how to do this is to create a SQL View which joins the table and have subsonic generate an object that maps to it.

You can also use ExecuteTypedList with a custom defined object for example:

public class TestObject{
  int Column1 { get; set; }
  int Column2 { get; set; }
}

List<TestObject> testObjects = DB.Select(Table1.Columns.Column1, Table2.Columns.Column2)
  .From(Table1.Schema)
  .InnerJoin(Table2.Schema)
  .ExecuteTypedList<TestObject>();

Related Solutions

Sql – Subsonic 2.2 Generated Property for SQL Server 2008 Date

Submit an issue here: http://code.google.com/p/subsonicproject/issues/list

R – Oracle Stored Procedures in SubSonic 2.2

I was able to fix a lot of the issues with the Oracle Provider in SubSonic in version 2.1 and most all of my fixes made it into 2.2. I didn't work on fixing the SP generation portion of the Oracle Provider as I only had one or two SPs. Even if the SP generation isn't working you can still use SPs with the Oracle Provider. I simply added the SPs by hand (see below) as a partial class in the altered folder I use to add functionality to the classes SubSonic generates.

example

    public partial class SPs
{
    public static decimal CreateSp(string username, string labelNote)
    {
        Decimal returnId = 0;
        SubSonic.StoredProcedure sp = new StoredProcedure("User.MySP");
        sp.Command.Parameters.Add("username", username, DbType.String);
        sp.Command.Parameters.Add("labelnote", labelNote, DbType.String);
        sp.Command.Parameters.Add("returnId", returnId, DbType.Decimal, ParameterDirection.Output);
        sp.Execute();
        return Convert.ToDecimal(sp.Command.Parameters.Find(delegate(QueryParameter qp) { return qp.ParameterName == "returnId"; }).ParameterValue);
    }

}

Best Answer

Related Solutions

Sql – Subsonic 2.2 Generated Property for SQL Server 2008 Date

R – Oracle Stored Procedures in SubSonic 2.2

Related Topic