C# (CSharp) FetchInsertedKeyLocation Examples

Example #1

File: SqlServerDialect.cs Project: fossabot/HQ.Lingo

        public override bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
        {
            switch (location)
            {
            case FetchInsertedKeyLocation.BeforeValues:
                sql = "OUTPUT Inserted.Id";
                return(true);

            default:
                sql = null;
                return(false);
            }
        }

Example #2

        public override bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
        {
            switch (location)
            {
            case FetchInsertedKeyLocation.AfterStatement:
                sql = "SELECT LAST_INSERT_ROWID() AS \"Id\"";
                return(true);

            default:
                sql = null;
                return(false);
            }
        }

Example #3

        public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
        {
            switch (location)
            {
            case FetchInsertedKeyLocation.AfterStatement:
                sql = $"SELECT LAST_INSERT_ROWID() AS {Quote}Id{Quote}";
                return(true);

            case FetchInsertedKeyLocation.BeforeValues:
                sql = null;
                return(false);

            default:
                sql = null;
                return(false);
            }
        }

Example #4

File: SqlDialect.cs Project: fossabot/HQ.Lingo

 public abstract bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql);

Example #5

 public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
 {
     sql = null;
     return(false);
 }

Example #6

 public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
 {
     throw new NotImplementedException();
 }