using (lnkTRADERDataContext DATActx = new lnkTRADERDataContext()) { var qryBOOK = from B in DATActx.BOOKs where B.DEAL == 1 select new clsTRADER() { P_C = B.P_C, //main table STRIKE = B.STRIKE, //main table OPT_EXP = B.OPTIONs.Single(X => X.OPT_EXPIRY), //one tier down OPT_MULT = B.OPTIONs.Single(X => X.OPT_MULTIPLIER), //one tier down SKEW_A = B.OPTIONs.SKEWs.Single(X => X.SKEW_A) // two tiers down }; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)