예제 #1
0
        public List <dynamic> Select(int pageNumber, int pageSize, List <FilterParameter> filter)
        {
            if (!_isReadyForUse)
            {
                throw new InvalidOperationException("Call \"Build\" method first!");
            }

            DataTranslator translator = new DataTranslator(_metadata);

            string sql = BuildPagingSelect(filter);

            List <dynamic> result = new List <dynamic>();

            using (SqlConnection connection = new SqlConnection(_metadata.InfoBase.ConnectionString))
                using (SqlCommand command = new SqlCommand(sql, connection))
                {
                    connection.Open();
                    command.Parameters.AddWithValue("start", (pageNumber - 1) * pageSize + 1);
                    command.Parameters.AddWithValue("end", pageNumber * pageSize);
                    AddFilterParameters(filter, command.Parameters);
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            dynamic item = new ExpandoObject();
                            translator.Translate(reader, (IDictionary <string, object>)item);
                            result.Add(item);
                        }
                    }
                }
            return(result);
        }
예제 #2
0
        public List <dynamic> Select()
        {
            if (!_isReadyForUse)
            {
                throw new InvalidOperationException("Call \"Build\" method first!");
            }

            DataTranslator translator = new DataTranslator(_metadata);

            List <dynamic> result = new List <dynamic>();

            using (SqlConnection connection = new SqlConnection(_metadata.InfoBase.ConnectionString))
                using (SqlCommand command = new SqlCommand(_select, connection))
                {
                    connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            dynamic item = new ExpandoObject();
                            translator.Translate(reader, (IDictionary <string, object>)item);
                            result.Add(item);
                        }
                    }
                }
            return(result);
        }