// Combo of Dapper, EF and a stored proc that was published through SSDT
static void Main(string[] args)
{
  var connectionString = ConfigurationManager
    .ConnectionStrings["DbDataContext"].ConnectionString;

  using (var conn = new SqlConnection(connectionString))
  using (var ctx = new DbDataContext())
  {
    conn.Open();

    var product = conn.Query<Product>("GetProduct",
      commandType: CommandType.StoredProcedure).First();

    ctx.Products.Attach(product);

    var order = new Order
    {
      Product = product
    };

    ctx.Orders.Add(order);

    ctx.SaveChanges();

  }
}