C# - Reading from JSON file

Question

I have problem with reading JSON file. File is inserted into Solution Explorer with Build Action set to Content and copy property se to Copy Always. I would expect then the file should be reachable from app in LocalFolder.

Stream localFolder = await ApplicationData.Current.LocalFolder.OpenStreamForReadAsync("sources.json");

string json;

using (StreamReader streamReader = new StreamReader(localFolder))
{
    json = streamReader.ReadToEnd();
}

return JsonConvert.DeserializeObject<List<SourceDefinition>>(json);

The error it is returning is:

Error: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)

Error: The system cannot find the file specified. (Exception from HRESULT: 0x80070002) — Jan Chalupa
– Jan Chalupa, Commented Feb 27, 2016 at 21:26
Are you getting the error when running through the Visual Studio or after the app is deployed? Also where exactly in you app did you place the file? — George M Ceaser Jr
– George M Ceaser Jr, Commented Feb 27, 2016 at 21:32
During debugging in Visual Studio. The code is placed in Background task (separated project but placed in same solution as main part of my app). I tried to place my sources.json file in both project's root but without any change. — Jan Chalupa
– Jan Chalupa, Commented Feb 27, 2016 at 21:36

Daniel Nachtrub · Accepted Answer · 2016-02-27 21:32:17Z

1

just try File.OpenRead - you're propably trying to open from AppData which is a special path within thr userprofile (%localappdata% in this case)

answered Feb 27, 2016 at 21:32

Daniel Nachtrub

3661 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

George M Ceaser Jr · Accepted Answer · 2016-02-27 22:07:06Z

1

So the ApplicationData.Current.LocalFolder point to the users\XXXXX\Local\Packages\YYYYYY\LocalState where XXXX is the user and YYYY is the GUID for your app. No folder in the project explorer actually points to that location to the best of my knowledge. You can try using the Windows.ApplicationModel.Package.Current. The InstalledLocation.Path will get you access to the bin where the app is running. Hope this helps.

answered Feb 27, 2016 at 22:07

George M Ceaser Jr

1,8313 gold badges28 silver badges65 bronze badges

Comments

user15139287 · Accepted Answer · 2021-07-02 11:59:32Z

0

Try this code for reading the json file on a scalable manner and binding to list model class

appsettings.json File

    "Mapping": {
        "Column1": {
          "ExcelColumnName": "DISTRIBUTOR UNIQUE ID",
          "DbFieldName": "vehicle_dealer_code",
          "IsRequired": "true",
          "DataType": ""
        },
        "Column1": {
          "ExcelColumnName": "FACTORY ORDER NUMBER",
          "DbFieldName": "vehicle_data02",
          "IsRequired": "true",
          "DataType": ""
        }
    public static T InitOptions<T>(string name, string section) where T : new()
            {
                var config = new ConfigurationBuilder()
                 .SetBasePath(AppContext.BaseDirectory)
                 .AddJsonFile(name, true, true)
                 .Build();
                return config.GetSection(section).Get<T>();
            }

   

    public class Config
        {
            public Mapping Column1 { get; set; }
            public Mapping Column2 { get; set; }        
        }

public class Mapping
{
    public string ExcelColumnName { get; set; }
    public string DbFieldName { get; set; }
    public bool IsRequired { get; set; }
    public string DataType { get; set; }
}

var MappedData = InitOptions<Config>("appsettings.json", "Mapping");

edited Jul 2, 2021 at 11:59

answered Jul 2, 2021 at 11:23

user15139287

11 bronze badge

1 Comment

Peter4499 Over a year ago

Hey, this question was from a long time ago and already answered. Your answer is very thorough though and appreciated. Please consider helping with some of the more recent posts.

Collectives™ on Stack Overflow

C# - Reading from JSON file

3 Answers 3

Comments

Comments

Try this code for reading the json file on a scalable manner and binding to list model class

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Try this code for reading the json file on a scalable manner and binding to list model class

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related