Esempio n. 1
0
        private void btnExecuteAsObjectUsingSqlQuery_Click(object sender, EventArgs e)
        {
            try
            {
                lblTitle.Text = "Execute As Object Using SQL Query : GET FILM BY ID";
                int    film_id = 133;
                string query   = QueryBase.GetFilmByID(film_id);

                Film film = null;
                Task.Factory.StartNew(() =>
                {
                    film = sqlHandler.ExecuteAsObjectUsingQuery <Film>(query);
                }).Wait();

                ICollection <Film> lstData = new List <Film>();
                lstData.Add(film);
                dgvResult.DataSource = lstData;
            }
            catch (Exception ex)
            {
                DisplayError(ex.Message);
            }
        }