Loading

With Core 2.2, How to reference a file programmatically

With Core 2.2, How to reference a file programmatically

Abraham Olatubosun

Abraham Olatubosun

6y816Visual Basic .NET

Dear All,

Hope this question meet you all in good health and happy holiday,

I am trying to access a file from a folder programatically like this :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;
using IQCARE_NMRS.PayLoads;
using Microsoft.Extensions.Configuration;
using MySql.Data.MySqlClient;
using Microsoft.AspNetCore.Hosting;

cmd.CommandText = System.IO.File.ReadAllText(HostingEnvironment.MapPath(Path.Combine("~/procedures", "spGetEncountersAndLabs.sql")));
cmd.ExecuteNonQuery();

the the above text in red is the error part i am need you guys to show me what am not doing right.

I need your help since i am new in asp.net core

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
In ASP.NET Core, however, the Server.MapPath() method doesn't exist anymore.
In fact, the Controller base class doesn't even have a Server property.
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;

namespace AspNetCorePathMapping
{
    public class HomeController : Controller
    {
        private readonly IWebHostEnvironment _env;

        public HomeController(IWebHostEnvironment env)
        {
            _env = env;
        }

        public ActionResult Index()
        {
            string contentRootPath = _env.ContentRootPath;
            string webRootPath = _env.WebRootPath;

            return Content(contentRootPath + "\n" + webRootPath);
        }
    }
The content root path is the absolute path to the directory that contains the application content files.
The web root path is the absolute path to the directory that contains the web-servable application content files.