using System;
using System.Data.SqlClient;
using Dapper;
using System.Linq;

namespace TestDapper {
	class Program {

		public struct Test {
			public int Id;
			public string Text;
		}

		static void Main(string[] args) {
			var db = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=MyDB;User ID=user;Password=password");
			var t = db.Query<Test>("select Id, Text from Test where Id = @Id", new { Id = 6 }).SingleOrDefault();
			Console.WriteLine(t.Id + " " + t.Text);
		}
	}
}

using System;
using System.Data.SqlClient;
using Dapper;
using System.Linq;

namespace TestDapper {
	class Program {

		static void Main(string[] args) {
			var db = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=MyDB;User ID=user;Password=password");
			var t = db.Query("select * from Test where Id = @Id", new { Id = 6 }).SingleOrDefault();
			Console.WriteLine(t.Id + " " + t.Text);
		}
	}
}

SELECT
    [Extent4].[ID] AS [ID],
    [Extent4].[AddrID] AS [AddrID],
    [Extent4].[Text] AS [Text]
    FROM   (SELECT DISTINCT
        [UnionAll1].[AddrID] AS [C1]
        FROM  (SELECT
            [Extent1].[AddrID] AS [AddrID]
            FROM [dbo].[UserAddr] AS [Extent1]
            WHERE ([Extent1].[UserID] = @p__linq__0) AND ([Extent1].[AddrID] IS NOT NULL)
        UNION ALL
            SELECT
            [Extent2].[AddrID] AS [AddrID]
            FROM  [dbo].[UserAddr] AS [Extent2]
            INNER JOIN [dbo].[GroupAddr] AS [Extent3] ON [Extent2].[GroupID] = [Extent3].[GroupID]
            WHERE [Extent2].[UserID] = @p__linq__1) AS [UnionAll1] ) AS [Distinct1]
    INNER JOIN [dbo].[Doc] AS [Extent4] ON [Distinct1].[C1] = [Extent4].[AddrID]
-- p__linq__0: '123' (Type = Int32, IsNullable = false)
-- p__linq__1: '123' (Type = Int32, IsNullable = false)

SELECT
    [Extent1].[ID] AS [ID],
    [Extent1].[AddrID] AS [AddrID],
    [Extent1].[Text] AS [Text]
    FROM [dbo].[Doc] AS [Extent1]
    WHERE  EXISTS (SELECT
        1 AS [C1]
        FROM ( SELECT DISTINCT
            [UnionAll1].[AddrID] AS [C1]
            FROM  (SELECT
                [Extent2].[AddrID] AS [AddrID]
                FROM [dbo].[UserAddr] AS [Extent2]
                WHERE ([Extent2].[UserID] = @p__linq__0) AND ([Extent2].[AddrID] IS NOT NULL)
            UNION ALL
                SELECT
                [Extent3].[AddrID] AS [AddrID]
                FROM  [dbo].[UserAddr] AS [Extent3]
                INNER JOIN [dbo].[GroupAddr] AS [Extent4] ON [Extent3].[GroupID] = [Extent4].[GroupID]
                WHERE [Extent3].[UserID] = @p__linq__1) AS [UnionAll1]
        )  AS [Distinct1]
        WHERE [Distinct1].[C1] = [Extent1].[AddrID]
    )
-- p__linq__0: '123' (Type = Int32, IsNullable = false)
-- p__linq__1: '123' (Type = Int32, IsNullable = false)

SELECT
    [Extent1].[ID] AS [ID],
    [Extent1].[AddrID] AS [AddrID],
    [Extent1].[Text] AS [Text]
    FROM [dbo].[Doc] AS [Extent1]
    WHERE  EXISTS (SELECT
        1 AS [C1]
        FROM  (SELECT
            [Extent2].[AddrID] AS [AddrID]
            FROM [dbo].[UserAddr] AS [Extent2]
            WHERE ([Extent2].[UserID] = @p__linq__0) AND ([Extent2].[AddrID] IS NOT NULL)
        UNION ALL
            SELECT
            [Extent3].[AddrID] AS [AddrID]
            FROM  [dbo].[UserAddr] AS [Extent3]
            INNER JOIN [dbo].[GroupAddr] AS [Extent4] ON [Extent3].[GroupID] = [Extent4].[GroupID]
            WHERE [Extent3].[UserID] = @p__linq__1) AS [UnionAll1]
        WHERE [UnionAll1].[AddrID] = [Extent1].[AddrID]
    )
-- p__linq__0: '123' (Type = Int32, IsNullable = false)
-- p__linq__1: '123' (Type = Int32, IsNullable = false)