title: Linq to EF guid in where clause always returns null
body: <p>I've tried many different ways and the "topic" is always null from the LINQ statement.  Is there something special that has to be done when comparing GUIDs with SQLite as the data source?</p>
  
  <pre><code>    public TopicModel GetTopicModel(Guid id)
      {
          TopicModel topicModel = null;
          using (var context = new onenessEntities())
          {
              var topic = context.Topics.FirstOrDefault(x =&gt; x.Id.Equals(id));
  
              if (topic != null)
              {
                  topicModel = new TopicModel
                  {
                      Id = topic.Id,
                      Description = topic.Description,
                      Title = topic.Title
                  };
              }
          }
  
          return topicModel;
      }
  </code></pre>
  
  <p>Auto Generated SQL</p>
  
  <pre><code>SELECT 
  [Extent1].[Id] AS [Id], 
  [Extent1].[CategoryId] AS [CategoryId], 
  [Extent1].[Language] AS [Language], 
  [Extent1].[Title] AS [Title], 
  [Extent1].[Description] AS [Description], 
  [Extent1].[Keywords] AS [Keywords], 
  [Extent1].[Version] AS [Version], 
  [Extent1].[CurrentPosition] AS [CurrentPosition], 
  [Extent1].[Notes] AS [Notes]
  FROM [Topic] AS [Extent1]
  WHERE ([Extent1].[Id] = @p__linq__0) AND (@p__linq__0 IS NOT NULL) LIMIT 1
  
  
  -- p__linq__0: '90f8f2c6-31cf-47a1-b8fb-61d5f4130d8f' (Type = AnsiStringFixedLength)
  
  -- Executing at 9/17/2015 2:56:37 PM -05:00
  
  -- Completed in 1 ms with result: SQLiteDataReader
  </code></pre>
  
  <p><strong>Edit</strong>:
  I've learned this issue is due to SQLite storing GUIDs as binary blobs.  As a work around I changed the data type from GUID to CHAR(36) and now am able to use LINQ to EF to retrieve the records.  I'd still like to see if someone can answer this original question though.</p>