DataAccessLayer.DataBase.GetAllPosts C# (CSharp) Method

GetAllPosts() public method

public GetAllPosts ( ) : List
return List
        public List<Post> GetAllPosts()
        {
            string queryString =
                "SELECT [dbo].posts.postid, posts.postname, posts.source, posts.createdtime, posts.accountid, posts.rating, posts.[text], [dbo].accounts.[login], tag, [dbo].posts.mimetype " +
                "FROM [dbo].posts, [dbo].tags, [dbo].accounts " +
                "WHERE (([dbo].tags.postid = [dbo].posts.postid) AND ([dbo].posts.accountid = [dbo].accounts.accountid))";

            List<Post> _list;

            using (SqlConnection connection = new SqlConnection(_connectionString))
            {
                var command = new SqlCommand(queryString, connection);

                connection.Open();
                var reader = command.ExecuteReader();

                if (reader == null)
                {
                    return null;
                }

                _list = new List<Post>();

                while (reader.Read())
                {
                    _list.Add(new Post()
                    {
                        PostId = (Guid)reader[0],
                        NamePost = (string)reader[1],
                        Image = (byte[])reader[2],
                        CreatedTime = (DateTime)reader[3],
                        AccountId = (Guid)reader[4],
                        Rating = (int)reader[5],
                        Text = (string)reader[6],
                        AuthorName = (string)reader[7],
                        Tags = ((string)reader[8]).Split(','),
                        MimeType = (string)reader[9]
                    });
                    var exec = _list;
                }

                return _list;
            }
        }