C# (CSharp) DefaultSqlExpression.Select Exemples

Exemple #1

Fichier : ExpressionFluentTests.cs Projet : 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);
        }

Exemple #2

Fichier : ExpressionFluentTests.cs Projet : 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);
        }

Exemple #3

Fichier : ExpressionFluentTests.cs Projet : 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);
 }

Exemple #4

Fichier : ExpressionFluentTests.cs Projet : 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);
        }