C# (CSharp) SharpQuery.SelectOne Examples

Example #1

File: SelectTestsSpecial.cs Project: codeinsiders/sharpql

        public void SingleExprSingleColumnSelect()
        {
            var q = new SharpQuery();

            var selectStm = q.SelectOne(2).Statement;
            var exp = (Expression)selectStm;

            q.Select(exp).EndStatement();

            var sqlString = q.ToString();
            TSqlAssert.ScriptsAreEqual(sqlString, @"
            SELECT
            ( SELECT TOP (  @p0  )      @p1 )
            ");
        }

Example #2

        public void SingleExprSingleColumnSelect()
        {
            var q = new SharpQuery();

            var selectStm = q.SelectOne(2).Statement;
            var exp       = (Expression)selectStm;

            q.Select(exp).EndStatement();

            var sqlString = q.ToString();

            TSqlAssert.ScriptsAreEqual(sqlString, @"
SELECT
    ( SELECT TOP (  @p0  )      @p1 )
");
        }