public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
GreaterThanOrEqual gOrEqual = new GreaterThanOrEqual();
List<GreaterThanOrEqual_Result> linqResults = gOrEqual.GreaterThanOrEqual_Method(DateTime.Now);
linqStopWatch.Stop();
Stopwatch efStopW = new Stopwatch();
efStopW.Start();
var context = new AWorksLTEntities();
List<GreaterThanOrEqual_Result> efResults = new List<GreaterThanOrEqual_Result>();
foreach (GreaterThanOrEqual_Result g in context.GreaterThanOrEqual(DateTime.Now))
{
efResults.Add(g);
}
efStopW.Stop();
if (linqResults.Count == efResults.Count)
{
writeToFile(linqResults, efResults, linqStopWatch, efStopW);
}
}
public void runTest()
{
//Create a stopwatch
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereBetweenValues whereBetween = new WhereBetweenValues();
List<WhereBetweenValues_Result> linqSubset = whereBetween.WhereBetweenValues_Method(680, 713);
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereBetweenValues_Result> efWhereBetween = new List<WhereBetweenValues_Result>();
foreach (WhereBetweenValues_Result w in context.WhereBetweenValues(680, 713))
{
efWhereBetween.Add(w);
}
efStopWatch.Stop();
if (linqSubset.Count() == efWhereBetween.Count())
{
writeToFile(linqSubset, efWhereBetween, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
// Call the generated Linq method and count
Stopwatch linqstopwatch = new Stopwatch();
linqstopwatch.Start();
SelectDistinct selectdistinct = new SelectDistinct();
List<SelectDistinct_Result> distinctList = selectdistinct.SelectDistinct_Method();
linqstopwatch.Stop();
// Call via the Stored Procedures
Stopwatch efstopwatch = new Stopwatch();
efstopwatch.Start();
var context = new AWorksLTEntities();
List<SelectDistinct_Result> sdResultList = new List<SelectDistinct_Result>();
foreach (SelectDistinct_Result sdRes in context.SelectDistinct())
{
sdResultList.Add(sdRes);
}
efstopwatch.Stop();
if (distinctList.Count() == sdResultList.Count())
{
writeToFile(distinctList, sdResultList, linqstopwatch, efstopwatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
InnerJoinWhereMethod inJoinMethod = new InnerJoinWhereMethod();
List<InnerJoinWhereMethod_Result> linqResults = inJoinMethod.InnerJoinWhereMethod_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<InnerJoinWhereMethod_Result> efResults = new List<InnerJoinWhereMethod_Result>();
foreach (InnerJoinWhereMethod_Result i in context.InnerJoinWhereMethod())
{
efResults.Add(i);
}
efStopWatch.Stop();
if (linqResults.Count == efResults.Count)
{
writeToFile(linqResults, efResults, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereComparisonOperator whereCompOp = new WhereComparisonOperator();
List<WhereComparisonOperator_Result> linqresult = whereCompOp.WhereComparisonOperator_Method("LL Road Frame - Red, 52", 2);
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereComparisonOperator_Result> efWhereCompArg = new List<WhereComparisonOperator_Result>();
foreach (WhereComparisonOperator_Result w in context.WhereComparisonOperator("LL Road Frame - Red, 52", 2))
{
efWhereCompArg.Add(w);
}
efStopWatch.Stop();
if (linqresult.Count() == efWhereCompArg.Count())
{
writeToFile(linqresult, efWhereCompArg, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereClauseOneArgument whereOneArg = new WhereClauseOneArgument();
List<WhereClauseOneArgument_Result> linqresult = whereOneArg.WhereClauseOneArgument_Method("LL Road Frame - Red, 52", "red");
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereClauseOneArgument_Result> efWhereOneArg = new List<WhereClauseOneArgument_Result>();
foreach (WhereClauseOneArgument_Result w in context.WhereClauseOneArgument("LL Road Frame - Red, 52", "red"))
{
efWhereOneArg.Add(w);
}
efStopWatch.Stop();
if (linqresult.Count() == efWhereOneArg.Count())
{
writeToFile(linqresult, efWhereOneArg, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereSeveralConditions whSevCond = new WhereSeveralConditions();
List<WhereSeveralConditions_Result> linqResults = whSevCond.WhereSeveralConditions_Method("p", "red");
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereSeveralConditions_Result> efResults = new List<WhereSeveralConditions_Result>();
foreach (WhereSeveralConditions_Result w in context.WhereSeveralConditions("p", "red"))
{
efResults.Add(w);
}
efStopWatch.Stop();
if (linqResults.Count() == efResults.Count())
{
writeToFile(linqResults, efResults, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
//Create a stopwatch
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
SelectSubset selectSubset = new SelectSubset();
List<SelectSubset_Result> linqSubset = selectSubset.SelectSubset_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<SelectSubset_Result> efSubset = new List<SelectSubset_Result>();
foreach (SelectSubset_Result sR in context.SelectSubset())
{
efSubset.Add(sR);
}
efStopWatch.Stop();
if (linqSubset.Count() == efSubset.Count())
{
writeToFile(linqSubset, efSubset, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
//Create a stopwatch
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
// Call the linq method
SelectMultipleDistinct selectMultipleD = new SelectMultipleDistinct();
List<SelectMultipleDistinct_Result> multiplelist = selectMultipleD.SelectMultipleDistinct_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<SelectMultipleDistinct_Result> multipleResults = new List<SelectMultipleDistinct_Result>();
foreach (SelectMultipleDistinct_Result mdr in context.SelectMultipleDistinct())
{
multipleResults.Add(mdr);
}
efStopWatch.Stop();
if (multiplelist.Count() == multipleResults.Count())
{
writeToFile(multiplelist, multipleResults, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereLikeString whereLikeString = new WhereLikeString();
List<WhereLikeString_Result> linqResults = whereLikeString.WhereLikeString_Method("LL Road Frame - Red, 52");
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereLikeString_Result> efLikeString = new List<WhereLikeString_Result>();
foreach (WhereLikeString_Result w in context.WhereLikeString("LL Road Frame - Red, 52"))
{
efLikeString.Add(w);
}
efStopWatch.Stop();
if (linqResults.Count() == efLikeString.Count())
{
writeToFile(linqResults, efLikeString, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
CInnerJoin cInnerJoin = new CInnerJoin();
List<CInnerJoin_Result> cJoinList = cInnerJoin.CInnerJoin_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<CInnerJoin_Result> cInnerJoinList = new List<CInnerJoin_Result>();
foreach (CInnerJoin_Result c in context.CInnerJoin())
{
cInnerJoinList.Add(c);
}
efStopWatch.Stop();
if (cJoinList.Count() == cInnerJoinList.Count())
{
writeToFile(cJoinList, cInnerJoinList, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereSimpleEquality wSimpleE = new WhereSimpleEquality();
List<WhereSimpleEquality_Result> linqResult = wSimpleE.WhereSimpleEquality_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<WhereSimpleEquality_Result> efResults = new List<WhereSimpleEquality_Result>();
foreach (WhereSimpleEquality_Result w in context.WhereSimpleEquality())
{
efResults.Add(w);
}
efStopWatch.Stop();
if (linqResult.Count == efResults.Count)
{
writeToFile(linqResult, efResults, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
WhereEqualsString wEqualString = new WhereEqualsString();
List<WhereEqualsString_Result> linqResults = wEqualString.WhereEqualsString_Method();
linqStopWatch.Stop();
Stopwatch efStopW = new Stopwatch();
efStopW.Start();
var context = new AWorksLTEntities();
List<WhereEqualsString_Result> efResults = new List<WhereEqualsString_Result>();
foreach(WhereEqualsString_Result w in context.WhereEqualsString())
{
efResults.Add(w);
}
efStopW.Stop();
if (linqResults.Count == efResults.Count)
{
writeToFile(linqResults, efResults, linqStopWatch, efStopW);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
SelectAll selectAll = new SelectAll();
List<SelectAll_Result> selectAllList = selectAll.SelectAll_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<SelectAll_Result> efSelectAllList = new List<SelectAll_Result>();
foreach (SelectAll_Result s in context.SelectAll())
{
efSelectAllList.Add(s);
}
efStopWatch.Stop();
if (selectAllList.Count() == efSelectAllList.Count())
{
writeToFile(selectAllList, efSelectAllList, linqStopWatch, efStopWatch);
}
}
public void runTest()
{
Stopwatch linqStopWatch = new Stopwatch();
linqStopWatch.Start();
SelectWhereNoParams whereNoParam = new SelectWhereNoParams();
List<SelectWhereNoParams_Result> linqResults = whereNoParam.SelectWhereNoParams_Method();
linqStopWatch.Stop();
Stopwatch efStopWatch = new Stopwatch();
efStopWatch.Start();
var context = new AWorksLTEntities();
List<SelectWhereNoParams_Result> efResults = new List<SelectWhereNoParams_Result>();
foreach (SelectWhereNoParams_Result s in context.SelectWhereNoParams())
{
efResults.Add(s);
}
efStopWatch.Stop();
if (linqResults.Count == efResults.Count)
{
writeToFile(linqResults, efResults, linqStopWatch, efStopWatch);
}
}
/// <summary>
/// This method finds all the associated properties of an object
/// Then using reflection obtains the type of the property
/// Then calls the method GetCoreType to fine the underlying type if the type is returned as Nullable.
/// </summary>
/// <param name="list">A list of Tokens </param>
/// <returns>The list of tokens with the dataType property completed</returns>
public static List<Token> gDataType(List<Token> list)
{
DataBaseLayer.AWorksLTEntities db = new AWorksLTEntities();
DataBaseLayer.Product product = new DataBaseLayer.Product();
foreach (var t in list)
{
if (t.Sql == "param")
{
foreach (var prop in product.GetType().GetProperties())
{
var proptype = prop.PropertyType;
var coretype = GetCoreType(proptype).Name;
}
}
}
return list;
}