InsertOrUpdate Support

[Sicos1977]

Hi,

Is it possible to do something like this with sqlKata?

IF EXISTS
(
    SELECT  1
    FROM    [Example]
    WHERE   Id = @Id
)
BEGIN

    UPDATE  [Example]
    SET     [ChangedDate] = GETDATE(),
            [Example1]    = @Example1
    WHERE   [Id]          = @Id

END
ELSE
BEGIN

    INSERT INTO [Example]
    (
        [ChangedDate],
        [Example1],
    )
    Values
    (
        GETDATE(),
        @Example1
    )

END

[Sicos1977]

I like your project. I cloned it and doing some code cleanup and adding comment.

[ahmad-moussawi]

Hi Thanks for your warm feedback, for your case no there is no direct way to achieve that, raw statements may be useful for this case
#94

Side note: be aware that the provided query can lead to reading phantom data.

[Sicos1977]

Are you open for a pull request to support table hints?

[ahmad-moussawi]

yes sure

[Sicos1977]

Also a small question why are you using lower case for some methods?
For example the getOr() and getNot() methods? These should normally start with a uppercase G.

Do you mind if a do some code cleanup to conform to Microsoft coding rules and put that in a pull request?

[ahmad-moussawi]

Actually I didn't find a clear documentation how to name protected variables :/, I am new to c# world :),
so go ahead if it's not aligned with C# coding guideline

[Sicos1977]

It looks like you are coming from the Java world. I did send you a Pull request with support for hints and some code cleanup... more will follow. It will take me some days to cleanup everything :-). But never mind you did a fantastic job with this library.

[ahmad-moussawi]

closing, tracking this feature on #103