{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/2850","repository_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore","labels_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/2850/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/2850/comments","events_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/2850/events","html_url":"https://github.com/aspnet/EntityFrameworkCore/issues/2850","id":101166729,"node_id":"MDU6SXNzdWUxMDExNjY3Mjk=","number":2850,"title":"Query: Provide EF.Functions to define methods that correspond to standard SQL operations","user":{"login":"roji","id":1862641,"node_id":"MDQ6VXNlcjE4NjI2NDE=","avatar_url":"https://avatars0.githubusercontent.com/u/1862641?v=4","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"labels":[{"id":403964217,"node_id":"MDU6TGFiZWw0MDM5NjQyMTc=","url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/labels/closed-fixed","name":"closed-fixed","color":"777777","default":false},{"id":76481854,"node_id":"MDU6TGFiZWw3NjQ4MTg1NA==","url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/labels/type-enhancement","name":"type-enhancement","color":"bfe5bf","default":false},{"id":178029136,"node_id":"MDU6TGFiZWwxNzgwMjkxMzY=","url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/labels/up-for-grabs","name":"up-for-grabs","color":"0070FF","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/milestones/24","html_url":"https://github.com/aspnet/EntityFrameworkCore/milestone/24","labels_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/milestones/24/labels","id":2044943,"node_id":"MDk6TWlsZXN0b25lMjA0NDk0Mw==","number":24,"title":"2.0.0-preview1","description":"","creator":{"login":"rowanmiller","id":4741851,"node_id":"MDQ6VXNlcjQ3NDE4NTE=","avatar_url":"https://avatars2.githubusercontent.com/u/4741851?v=4","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":222,"state":"closed","created_at":"2016-10-03T18:11:14Z","updated_at":"2017-11-06T22:37:41Z","due_on":null,"closed_at":"2017-05-16T03:56:06Z"},"comments":43,"created_at":"2015-08-15T11:14:06Z","updated_at":"2018-07-02T21:22:10Z","closed_at":"2017-05-10T01:05:23Z","author_association":"CONTRIBUTOR","body":"Not sure whether this has already been discussed (or makes sense).\n\nThere are some standard SQL operations that don't correspond to an already-existing .NET method; the example that comes to mind is LIKE. It seems that up to now, each provider invented its own way to allow users to specify these in LINQ to Entities - SqlClient has [SqlFunctions](https://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396) and [SqlMethods](https://msdn.microsoft.com/en-us/library/system.data.linq.sqlclient.sqlmethods%28v=vs.110%29.aspx).\n\nIt seems to makes sense to pull the standard SQL functions and methods out of these SQL Server-specific classes and place them in the generic EF7 code, this way the same LINQ can be used across different providers...\n"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/comments/401940392","html_url":"https://github.com/aspnet/EntityFrameworkCore/issues/2850#issuecomment-401940392","issue_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/2850","id":401940392,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTk0MDM5Mg==","user":{"login":"pmiddleton","id":11600726,"node_id":"MDQ6VXNlcjExNjAwNzI2","avatar_url":"https://avatars1.githubusercontent.com/u/11600726?v=4","gravatar_id":"","url":"https://api.github.com/users/pmiddleton","html_url":"https://github.com/pmiddleton","followers_url":"https://api.github.com/users/pmiddleton/followers","following_url":"https://api.github.com/users/pmiddleton/following{/other_user}","gists_url":"https://api.github.com/users/pmiddleton/gists{/gist_id}","starred_url":"https://api.github.com/users/pmiddleton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pmiddleton/subscriptions","organizations_url":"https://api.github.com/users/pmiddleton/orgs","repos_url":"https://api.github.com/users/pmiddleton/repos","events_url":"https://api.github.com/users/pmiddleton/events{/privacy}","received_events_url":"https://api.github.com/users/pmiddleton/received_events","type":"User","site_admin":false},"created_at":"2018-07-02T21:22:10Z","updated_at":"2018-07-02T21:22:10Z","author_association":"CONTRIBUTOR","body":"@MikeDempseyFL Are you implementing a provider or are you just using EF Core in a project?  "}}
{"actor":{"display_login":"pmiddleton"}}