private buildGetFolderQuery ( |
||
folderId | ||
Résultat | OracleQuery |
public void testGetFolderSql() { FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource() { ConnectionString = "MyCxnString" })); OracleQuery result = dao.buildGetFolderQuery(1); Assert.IsNotNull(result); Assert.AreEqual("SELECT FOLDER_ID, USER_ID, FOLDER_NAME, OPLOCK AS FOLDOPLOCK FROM SMS.FOLDER WHERE FOLDER_ID=:folderId AND ACTIVE=1", result.Command.CommandText); Assert.AreEqual(1, result.Command.Parameters.Count); Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[0].DbType); Assert.AreEqual("folderId", result.Command.Parameters[0].ParameterName); Assert.AreEqual(1, result.Command.Parameters[0].Value); Assert.AreEqual(1, result.Command.Parameters.Count); }
public void testGetFolderSql() { FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource() { ConnectionString = "MyCxnString" })); OracleQuery result = dao.buildGetFolderQuery(1); Assert.IsNotNull(result); Assert.AreEqual("SELECT FOLDER_ID, USER_ID, FOLDER_NAME, OPLOCK AS FOLDOPLOCK FROM SMS.FOLDER WHERE FOLDER_ID=:folderId AND ACTIVE=1", result.Command.CommandText); Assert.AreEqual(1, result.Command.Parameters.Count); Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[0].DbType); Assert.AreEqual("folderId", result.Command.Parameters[0].ParameterName); Assert.AreEqual(1, result.Command.Parameters[0].Value); Assert.AreEqual(1, result.Command.Parameters.Count); }