title: Is it possible to test SQL data in a C# unit test?
body: <pre><code>public ApplicationLayout Get(string objectName, string userName)
  {
      using (var db = new SqlConnection(_connectionString))
      {
          var sql = "SELECT * FROM dbo.ApplicationLayout WHERE ObjectName = @ObjectName AND UserName=@UserName";
  
          return db.Query&lt;ApplicationLayout&gt;(sql, new {ObjectName = objectName, UserName = userName}).FirstOrDefault();
      } 
  }
  </code></pre>
  
  <p>I have some code here, and I was wondering if it is possible to perform a unit test in C# using SQL data (any framework). From what I've seen, it is not possible. Can anyone please confirm this?</p>