C# (CSharp) System.Data.OleDb.OleDbConnection.QuerySql Exemples

Exemple #1

Fichier : OleDbTest.cs Projet : Jaxelr/Insight.Database

        public void NamedParametersAreConvertedToPositionalParameters()
        {
            var c = new System.Data.OleDb.OleDbConnection(
                String.Format("Provider=MSOLEDBSQL;Server={0};Uid={1};Pwd={2};Trusted_Connection=no",
                              TestHost, "sa", Password));
            dynamic i = c.QuerySql("SELECT p=@p, q=@q, r=@p", new { p = 5, q = 9 }).First();

            Assert.AreEqual(5, i.p);
            Assert.AreEqual(9, i.q);
            Assert.AreEqual(5, i.r);
        }