title: Cannot resolve the collation conflict between "Cyrillic_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
body: <p>MS SQL server 2017</p>
  
  <p>asp.net core 2</p>
  
  <p>I call store procedure from c#:</p>
  
  <pre><code>res = db.Query&lt;SearchPictureInfoOutputModel&gt;("sp_SearchPictureInfo", new { Prc_ID = input.Prc_ID, Cust_ID = input.Cust_ID, AppCode = input.AppCode},
                               commandType: CommandType.StoredProcedure).FirstOrDefault();
  </code></pre>
  
  <p>I get error:</p>
  
  <p><strong>System.Data.SqlClient.SqlException: 'Cannot resolve the collation conflict between "Cyrillic_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.'</strong></p>
  
  <p>If i call procedure from ms managment studio</p>
  
  <pre><code>DECLARE @return_value int
  
  EXEC    @return_value = [dbo].[sp_SearchPictureInfo]
          @Prc_ID = 2663,
          @Cust_ID = 26429,
          @AppCode = N'19139'
  
  SELECT  'Return Value' = @return_value
  
  GO
  </code></pre>
  
  <p>No error, just return value. </p>
  
  <p>How can I solve collation?</p>