Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New feature topic: built-in function mapping and EF.Functions #504

Closed
divega opened this issue Oct 6, 2017 · 1 comment · Fixed by #2705
Closed

New feature topic: built-in function mapping and EF.Functions #504

divega opened this issue Oct 6, 2017 · 1 comment · Fixed by #2705

Comments

@divega
Copy link
Contributor

divega commented Oct 6, 2017

Originally from #447.

Should cover EF.Functions.Like as well.

@ajcvickers ajcvickers added this to the 2.1.0 milestone Oct 6, 2017
@divega divega modified the milestones: 2.1.0, 2.2.0 Jul 10, 2018
@divega divega added the help wanted This issue involves technologies where we are not experts. Expert help would be appreciated. label Nov 5, 2018
@bricelam
Copy link
Contributor

bricelam commented Nov 9, 2018

It's over-simplified, but here's a good concept map for SQLite.

.NET SQLite
Array.Length length
DateTime.AddDays datetime
DateTime.AddHours datetime
DateTime.AddMilliseconds strftime
DateTime.AddMinutes datetime
DateTime.AddMonths datetime
DateTime.AddSeconds datetime
DateTime.AddTicks strftime
DateTime.AddYears datetime
DateTime.Date date
DateTime.Day strftime
DateTime.DayOfWeek strftime
DateTime.DayOfYear strftime
DateTime.Hour strftime
DateTime.Milisecond strftime
DateTime.Minute strftime
DateTime.Month strftime
DateTime.Now datetime
DateTime.Second strftime
DateTime.Ticks strftime
DateTime.TimeOfDay time
DateTime.Today datetime
DateTime.UtcNow datetime
DateTime.Year strftime
Math.Abs abs
Math.Max max
Math.Min min
Math.Round round
string.Contains instr
string.IndexOf instr
string.Length length
string.Replace replace
string.Substring substr
string.ToLower lower
string.ToUpper upper
string.Trim trim
string.TrimEnd rtrim
string.TrimStart ltrim

@divega divega removed help wanted This issue involves technologies where we are not experts. Expert help would be appreciated. labels Nov 10, 2018
@divega divega modified the milestones: 2.2.0, 3.0.0 Feb 21, 2019
@ajcvickers ajcvickers modified the milestones: 3.0.0, Backlog Aug 28, 2019
@ajcvickers ajcvickers modified the milestones: Backlog, 3.1.0 Sep 6, 2019
@ajcvickers ajcvickers modified the milestones: 3.1.0, 5.0.0 Jan 15, 2020
@bricelam bricelam removed their assignment Sep 4, 2020
@bricelam bricelam self-assigned this Sep 24, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 5, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 6, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 6, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 6, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 6, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 6, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 7, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 8, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 8, 2020
@bricelam bricelam removed their assignment Oct 8, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 8, 2020
bricelam added a commit to bricelam/EntityFramework.Docs that referenced this issue Oct 12, 2020
@smitpatel smitpatel linked a pull request Nov 10, 2020 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants