Ejemplos de UpdateDatabase DatabaseEngine.ExecuteDataTable en C# (CSharp)

Ejemplo n.º 1

        private List <int> GetSurveyIds()
        {
            var surveySids = m_DatabaseEngine.ExecuteDataTable <DataTable>(
                "SELECT SID FROM BvSurvey WHERE [Name] <> @TemplateSurveyName",
                CommandType.Text,
                new SqlParameter(
                    "@TemplateSurveyName",
                    Configuration.Default.TemplateSurveyName));

            var surveySidsList = new List <int>();

            foreach (DataRow row in surveySids.Rows)
            {
                surveySidsList.Add((int)row["SID"]);
            }

            return(surveySidsList);
        }