Putting in the backlog as a possible translation. One problem with this kind of translation is that it duplicates its argument (in this many times over); this is OK if the argument is a simple value (column), but if it's e.g. a complex scalar subquery, that would reevaluate the subquery many times over. At least at first, I'd not perform the translation in that case.

@roji
I would like to work on this method translation.
I am new to the repo, I will try to understand the translation and then start working on the code.
I think this PR would be a good reference to understand the method translation #31180

@mseada94 sure thing, go ahead.

@roji
Should I perform the translation for SQL Server Only and skip SQLite considering the issue #18844 and #25103?

I will start by adding two tests should these test be enough?

    [ConditionalTheory]
    [MemberData(nameof(IsAsyncData))]
    public virtual Task Where_DateOnly_ToDateTime_With_Constant_TimeOnly(bool async)
        => AssertQuery(
            async,
            ss => ss.Set<Mission>()
                .Where(o => o.Date.ToDateTime(new TimeOnly(21, 5, 19, 94)) == new DateTime(1990, 11, 10, 21, 5, 19, 94))
                .AsTracking());


    [ConditionalTheory]
    [MemberData(nameof(IsAsyncData))]
    public virtual Task Where_DateOnly_ToDateTime_With_Property_TimeOnly(bool async)
        => AssertQuery(
            async,
            ss => ss.Set<Mission>()
                .Where(o => o.Date.ToDateTime(o.Time) == new DateTime(1990, 11, 10, 10, 15, 50, 500))
                .AsTracking());

@mseada94 please submit a PR rather than posting implementation questions here - I'll review the PR (though it may take some time).

I created the PR as draft

• The translation is done as expected
• I have an issue in comparison between datetime and string, I need to cast const value as datetime please guide where to look
• TODO: add support for DateOnly as constant with TimeOnly Property