C# (CSharp) LoginUserLicense Beispiele

Beispiel #1

Datei: LoginUserLicenseQueryProcessor.cs Projekt: fwka1605/next

        public Task <LoginUserLicense> SaveAsync(LoginUserLicense license, CancellationToken token = default(CancellationToken))
        {
            string query = @"
MERGE INTO LoginUserLicense AS target
USING ( 
    SELECT 
     @CompanyId AS CompanyId
    ,@LicenseKey AS LicenseKey
) AS source
ON (
        target.CompanyId   = @CompanyId
    AND target.LicenseKey  = @LicenseKey
) 
WHEN MATCHED THEN
    UPDATE SET
        LicenseKey = @LicenseKey
WHEN NOT MATCHED THEN
    INSERT ( CompanyId,  LicenseKey)
    VALUES (@CompanyId, @LicenseKey)
OUTPUT inserted.*; ";

            return(dbHelper.ExecuteAsync <LoginUserLicense>(query, license, token));
        }

Beispiel #2

 public async Task <ActionResult <IEnumerable <LoginUserLicense> > > GetItems(LoginUserLicense license, CancellationToken token)
 => (await loginUserLicenseProcessor.GetAsync(license.CompanyId, token)).ToArray();