C# (CSharp) SalesOrderHeaders.Query Exemples

Exemple #1

        public void Query_Filter()
        {
            var soh          = new SalesOrderHeaders();
            var filteredRows = soh.Query("SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID=@0", 30052).ToList();

            Assert.AreEqual(4, filteredRows.Count);
        }

Exemple #2

        public void Query_AllRows()
        {
            var soh     = new SalesOrderHeaders();
            var allRows = soh.Query("SELECT * FROM Sales.SalesOrderHeader").ToList();

            Assert.AreEqual(31465, allRows.Count);
        }