如何在.NET中创建和使用资源

IHostingEnvironment _hostingEnvironment = new HostingEnvironment();

string connectionString = _hostingEnvironment.ContentRootPath + "/Data/dbConnection.db";

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
builder.UserName = "username";
builder.Password = "password123";
builder.Encrypt = true;

SqlConnection connection = new SqlConnection(builder.ConnectionString);

using System.Web;
using System.Web.Configuration;

var map = _hostingEnvironment.WebRootFileProvider.GetFileMap("images/test-image.jpg");
string filePath = map.PhysicalPath;

// 获取文件对象
using (StreamReader reader = new StreamReader(filePath))
using (FileStream writer = new FileStream(filePath, FileMode.CreateNew))
{
    reader.BaseStream.CopyTo(writer);
    writer.Close();
}

var config = Configuration.GetSection("custom-sections");
var optionsSection = config["options"];

var sampleOption = optionsSection["sampleOption"];
Console.WriteLine(sampleOption.Value);

IHostingEnvironment _hostingEnvironment = new HostingEnvironment();
string rootDirectory = _hostingEnvironment.ContentRootPath;

// 获取虚拟目录（根据实际需求确定是否需要）
var physicalPath = PhysicalPath(rootDirectory, "customSite");

// 创建 WebProjectBuilder 实例
WebProjectBuilder builder = new WebProjectBuilder(physicalPath, projectPaths =>
{
    projectPaths.AddDirectory("App\_Code");
    projectPaths.AddDirectory("Models");
    projectPaths.AddDirectory("Resources");
    projectPaths.AddFromFile("Web.config");
    projectPaths.AddFromFile("web\_content/index.chtml");

    // ... other project paths...
});
...