SqlLinq: Taking LINQ to SQL in the Other Direction

using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;

using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace FileDataProvider.UnitTests
{
    /// <summary>
    /// Summary description for ExceptionTests
    /// </summary>
    [TestClass]
    public class ExceptionTests
    {
        public ExceptionTests()
        {
        }

        private TestContext testContextInstance;

        /// <summary>
        ///Gets or sets the test context which provides
        ///inextensionion about and functionality for the current test run.
        ///</summary>
        public TestContext TestContext
        {
            get
            {
                return testContextInstance;
            }
            set
            {
                testContextInstance = value;
            }
        }

        [TestMethod]
        [ExpectedException(typeof(ParseException))]
        public void AggregateInWhereClause()
        {
            Shared.ExecuteQuery("SELECT bitrate FROM File, Media WHERE AVG(bitrate) = 128000");
        }

        [TestMethod]
        [ExpectedException(typeof(ParseException))]
        public void IncorrectSqlSyntax()
        {
            Shared.ExecuteQuery("SELECT FROM soundtrack");
        }


        [TestMethod]
        [ExpectedException(typeof(ArgumentException))]
        public void NonExistentRootDirectory()
        {
            FileDbConnectionStringBuilder builder = new FileDbConnectionStringBuilder();
            builder.Root = @"X:\abc\123\doesnotexist\";

            using (FileDbConnection connection = new FileDbConnection(builder.ConnectionString))
                connection.Open();
        }
    }
}