Deveel.Data.SelectClobTests.SelectBio C# (CSharp) Method

        public void SelectBio()
        {
            var exp = (SqlQueryExpression) SqlExpression.Parse("SELECT * FROM test_table");
            var result = AdminQuery.Select(exp);

            Assert.IsNotNull(result);
            Assert.IsTrue(result.Any());

            var row = result.FirstOrDefault();

            Assert.IsNotNull(row);

            var bio = row["bio"];

            Assert.IsFalse(Field.IsNullField(bio));
            Assert.IsInstanceOf<StringType>(bio.Type);
            Assert.AreEqual(SqlTypeCode.Clob, bio.Type.TypeCode);
            Assert.IsInstanceOf<SqlLongString>(bio.Value);

            var textReader = ((SqlLongString) bio.Value).GetInput(Encoding.ASCII);
            string text = null;
            Assert.DoesNotThrow(() => text = textReader.ReadToEnd());

            Assert.IsNotNullOrEmpty(text);
            Assert.AreEqual(testBio, text);
        }