Пример #1
0
        private void DeleteMasterRecords(string schemaName, List <Guid> recordIds, DBExecutor dbExecutor)
        {
            QueryParameterCollection queryParameterCollection = new QueryParameterCollection();

            foreach (Guid recordId in recordIds)
            {
                queryParameterCollection.Add(new QueryParameter(recordId));
            }
            if (queryParameterCollection.Count == 0)
            {
                throw new Exception("Invalid Query paramers exception. Collection cannot be empty/");
            }
            EntitySchema entitySchema      = UserConnection.EntitySchemaManager.GetInstanceByName(schemaName);
            string       primaryColumnName = entitySchema.GetDBPrimaryColumnName();
            var          delete            = new Delete(UserConnection).From(schemaName)
                                             .Where(primaryColumnName)
                                             .In(queryParameterCollection);

            delete.Execute(dbExecutor);
        }