title: Cannot resolve collation conflict, possible linq/EF solution per column?
body: <p>Attempting to insert new rows from a ASP.NET Core API with Entity Framework gives me this error:</p>
  
  <blockquote>
    <p>Cannot resolve the collation conflict between \"SQL_Latin1_General_CP1_CI_AS\" and \"SQL_Latin1_General_CP1_CS_AS\" in the equal to operation.</p>
  </blockquote>
  
  <p>I tried following the advice <a href="https://stackoverflow.com/questions/1607560/cannot-resolve-the-collation-conflict-between-sql-latin1-general-cp1-ci-as-and">here</a> - and indeed, there is a different collation set on the columns for the tables.</p>
  
  <p>Unfortunately we have been told we will not be allowed to alter the database (SQL Server) in any way. Is there any way to handle this per column when I insert the rows with EF (from the C# layer) so that it matches what the database expects? Or do I just have to tell the client "sorry, it's broken?" I'm not sure what to do at that point.</p>