Question: I'm working on an FAQ type project using AngularJS. I have a number of questions and answers I need to import into the page and thought it would be a good idea to use a service/directive to load the content in dynamically from JSON.

The text strings are quite unwieldily (639+ characters) and the overall hesitation I have is adding HTML into the JSON object to format the text (Line breaks etc). 

Is pulling HTML from JSON considered bad practice practice, and is there a better way to solve this? I'd prefer to avoid using multiple templates but it's starting to seem like a better approach.

Thanks

Answer: 
I replaced 

```
var listeRef = from r in db.refAnomalies
                   select r;

```

with 

```
String sql = @"select * from refAnomalie";
        List<refAnomalie> listeRefference = new List<refAnomalie>();
        var con =  new SqlConnection("data source=(LocalDb)\\MSSQLLocalDB;initial catalog=Banque;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework");
        using (var command= new SqlCommand(sql,con)){

            con.Open();
            using (var reader = command.ExecuteReader())
            {

                while (reader.Read())
                    listeRefference.Add(new refAnomalie
                    {
                        code_anomalie = reader.GetInt32(0),
                        libelle_anomalie = reader.GetString(1),
                        score_anomalie = reader.GetInt32(2),
                        classe_anomalie = reader.GetString(3)
                    });
                    }

        }

```

and it worked fine
The error message is quite clear: EF evidently generates a query simliar to...

```
select ..., rapportAnomalie_code_rapport, ...
from refAnomalie

```

...and the error tells you that there is no `rapportAnomalie_code_rapport` column in `refAnomalie`.

You need to take a look at the class that EF generates for `refAnomalie`. There is probably a reference to that mysterious column somewhere in there.