SogdianWarrior Comments - Answer Overflow

SogdianWarrior

Posts Comments

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

if that's what @baristaner is asking, then indeed EF isn't aware of the changes done by the stored procedure.

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

but the savechangesasync will handle the createdAt and modifiedAt

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

you can either do the code in C#, or you can let the stored procedure do it

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

something like this

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

ALTER PROCEDURE [dbo].[GenerateCodes]
    @NumOfCodes INT = 50,
    @CharacterSet NVARCHAR(50) = '13456789ACDEFHKLMNPQRTVWXYZ',
    @ExpirationMonths INT = 3,
    @ExpirationDate DATE = NULL /* TIME FORMAT ; YYYY-MM-DD */
AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @Counter INT = 1;

    BEGIN TRY
        BEGIN TRANSACTION;

        WHILE @Counter <= @NumOfCodes
        BEGIN
            DECLARE @RandomString VARCHAR(10);
            SET @ExpirationDate = DATEADD(MONTH, 3, GETDATE());
            SET @RandomString = '';

            DECLARE @InnerCounter INT = 1;
            WHILE @InnerCounter <= 10
            BEGIN
                SET @RandomString = @RandomString + SUBSTRING(@CharacterSet, (ABS(CHECKSUM(NEWID())) % LEN(@CharacterSet) + 1), 1);
                SET @InnerCounter = @InnerCounter + 1;
            END;

            SET @UtcNow = GETUTCDATE();
            INSERT INTO dbo.Codes (CODE, ExpirationDate,CreatedAt,ModifiedAt,IsActive)
            VALUES (@RandomString, @ExpirationDate,@UtcNow,@UtcNow,1);

            SET @Counter = @Counter + 1;
        END;

        COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH
        ROLLBACK TRANSACTION;

        PRINT 'An error occurred. Transaction rolled back.';
        PRINT ERROR_MESSAGE();
    END CATCH;
END;

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

I do see createdAt, but not modifiedAt

51 replies

CC#

•Created by baristaner on 12/27/2023 in #help

DateTime.UtcNow returns 0001-01-01T00:00:00

you dont insert anything into the ModifiedAt column?

51 replies

CC#