The Weird and The Wonderful

SELECT * FROM commontimetable WHERE CustomerId <> 'Customer one' AND CustomerId <> 'Customer tow' AND .... CustomerId <> 'Customer ***'

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel;
using System.Data.Objects.DataClasses;
using System.Data.Objects;
using System.Data;
using System.Reflection;

namespace DataObjectDemo {

[DataObject]
public abstract class BasicWebBO<TEntity, TKey, TContext>
        where TEntity : EntityObject,new()
        where TContext : ObjectContext, new() {

   private TContext _context;
   protected TContext Context {
            get {if (_context == null) {
                    _context = new TContext();
                }
                return _context;
            }
        }

   protected virtual string EntitySetName {
            get {
                return typeof(TEntity).Name;
            }
        }
    
[DataObjectMethod(DataObjectMethodType.Insert)]
public virtual void Insert(TEntity entity) {
   Context.AddObject(typeof(TEntity).Name,entity);
   Context.SaveChanges();
}

[DataObjectMethod(DataObjectMethodType.Update)]
public virtual void Update(TEntity entity) {
  Context.AttachTo(EntitySetName, entity);
  Context.ObjectStateManager.
  ChangeObjectState(
     entity, System.Data.EntityState.Modified);
  Context.ApplyCurrentValues(
     entity.EntityKey.EntitySetName, entity);
  Context.SaveChanges();
}

[DataObjectMethod(DataObjectMethodType.Delete)]
public virtual void Delete(TEntity entity) {
  Context.AttachTo(EntitySetName, entity);
  Context.DeleteObject(entity);
  Context.SaveChanges();
}

[DataObjectMethod(DataObjectMethodType.Select)]
public virtual TEntity Select(TKey key) {
//HACK: assume a scalar key and the key-property on index 0
  TEntity template = new TEntity();
  PropertyInfo pi = typeof(TEntity).GetProperties()[0];
  pi.SetValue(template, key, null);
  //
  EntityKey entityKey =
    Context.CreateEntityKey(EntitySetName, template);
  object entity;
  if (Context.TryGetObjectByKey(entityKey, out entity)) {
     return entity as TEntity;
  }
  return null;
}

 public class PersonBO : BasicWebBO<Person, int, DemoEntities> {
}

   [DataObjectMethod(DataObjectMethodType.Select)]
        public IEnumerable<Person> SelectAll() {
            return from person in Context.Person select person;
        }

        [DataObjectMethod(DataObjectMethodType.Update)]
        public void UpdateImage(int PNR, byte[] image) {
//...
}