I have a web application (ASP.NET Core / C#) with 3 layers (web/presentation, business logic and data access).
I'm using Entity Framework to retrieve a record from an SQL Server database which is subsequently mapped to my model object. One of the retrieved columns contains an XML string where I need to extract some values from and map them to some properties of my Model object.
Of course the retrieval of the database-record is done in the data access layer; but would you place the parsing from the XML string in the data access layer too (since it's a matter of extracting data) or would you rather place it into the business logic layer (since the data access layer should only deal with the database)?