C# (CSharp) DefaultSqlExpression.Select 예제들

예제 #1

파일: ExpressionFluentTests.cs 프로젝트: sekiya666/NPoco

        public void SelectStatementDoesNotRenderPropertyNameAsAlias()
        {
            var sqlExpression = new DefaultSqlExpression <UserDecorated>(Database);

            sqlExpression.Select(x => new { x.IsMale, x.Name });
            var selectStatement = sqlExpression.Context.ToSelectStatement();

            Assert.AreEqual("SELECT [is_male], [Name] \nFROM [Users] UD", selectStatement);
        }

예제 #2

파일: ExpressionFluentTests.cs 프로젝트: zirui-wang997/NPoco

        public void SelectStatementDoesNotRenderPropertyNameAsAlias()
        {
            var sqlExpression = new DefaultSqlExpression <UserDecorated>(Database);

            sqlExpression.Select(x => new { x.IsMale, x.Name });
            var selectStatement = sqlExpression.Context.ToSelectStatement();

            string expected = string.Format("SELECT {0}, {1} \nFROM {2}",
                                            TestDatabase.DbType.EscapeSqlIdentifier("is_male"),
                                            TestDatabase.DbType.EscapeSqlIdentifier("Name"),
                                            TestDatabase.DbType.EscapeTableName("Users"));

            Assert.AreEqual(expected, selectStatement);
        }

예제 #3

파일: ExpressionFluentTests.cs 프로젝트: rahulchavhan/NPoco

 public void SelectStatementDoesNotRenderPropertyNameAsAlias()
 {
     var sqlExpression = new DefaultSqlExpression<UserDecorated>(Database);
     sqlExpression.Select(x => new {x.IsMale, x.Name});
     var selectStatement = sqlExpression.Context.ToSelectStatement();
     Assert.AreEqual("SELECT [is_male],[Name] \nFROM [Users]", selectStatement);
 }

예제 #4

파일: ExpressionFluentTests.cs 프로젝트: rplaner/NPoco

        public void SelectStatementDoesNotRenderPropertyNameAsAlias()
        {
            var sqlExpression = new DefaultSqlExpression<UserDecorated>(Database);
            sqlExpression.Select(x => new {x.IsMale, x.Name});
            var selectStatement = sqlExpression.Context.ToSelectStatement();

            string expected = string.Format("SELECT {0}, {1} \nFROM {2}",
                                            TestDatabase.DbType.EscapeSqlIdentifier("is_male"),
                                            TestDatabase.DbType.EscapeSqlIdentifier("Name"),
                                            TestDatabase.DbType.EscapeTableName("Users"));

            Assert.AreEqual(expected, selectStatement);
        }