public static void Transfer(SupermarketsEntities sqlserver)
{
using (var mysql = new MySqlSupermarket())
{
// SET IDENTITY_INSERT (Transact-SQL) http://msdn.microsoft.com/en-us/library/ms188059.aspx
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Vendors ON");
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Measures ON");
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Products ON");
var mysqlTables = new IEnumerable[] { mysql.Vendors, mysql.Measures, mysql.Products };
var sqlserverEntityFactories = new Func<object>[] { () => new Vendor(), () => new Measure(), () => new Product() };
var sqlserverTables = new DbSet[] { sqlserver.Vendors, sqlserver.Measures, sqlserver.Products };
for (int ii = 0; ii < mysqlTables.Length; ii++)
{
foreach (var mysqlObject in mysqlTables[ii])
{
var sqlserverObject = sqlserverEntityFactories[ii]();
sqlserverObject.LoadPropertiesFrom(mysqlObject);
sqlserverTables[ii].Add(sqlserverObject);
}
}
sqlserver.SaveChanges();
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Vendors OFF");
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Measures OFF");
sqlserver.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Products OFF");
}
}
public NetworkRepository(DbSet<NetworkModel> networks, DbSet<ComputerModel> computers, Action save, DbSet<UserModel> users)
{
_networks = networks;
_computers = computers;
_save = save;
_users = users;
}
private void RemoveDbSetData(DbSet set)
{
foreach (var @entity in set)
{
set.Remove(@entity);
}
}
public FakeLagaModelDbContext()
{
LoggerEntries = new FakeDbSet<LoggerEntry>();
LoggerOperations = new FakeDbSet<LoggerOperation>();
LoggerThreads = new FakeDbSet<LoggerThread>();
LoggerThreadStatus = new FakeDbSet<LoggerThreadStatus>();
}
public ConnectedRepository()
{
_context = new NinjaContext();
_ninjas = _context.Ninjas;
_clans = _context.Clans;
_equipment = _context.Equipment;
}
public void RemoveDbSetDataDatabase(DbSet set)
{
RemoveDbSetData(set);
SaveChanges();
dataDeleter.DeleteAllObjects();
}
public ActivityLogTypeMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_activityLogTypeRecords = _ctx.Set<ActivityLogType>();
}
public static IQueryable<SetSubmission> NewestSubmissionsFromASub(string subverseName, DbSet<Message> messagesDbSet, string setName, int desiredResults)
{
var topRankedSubmissions = (from message in messagesDbSet
where !message.IsDeleted && message.Subverse == subverseName
select new SetSubmission
{
Id = message.Id,
Votes = message.Votes,
Name = message.Name,
Date = message.Date,
Type = message.Type,
Linkdescription = message.Linkdescription,
Title = message.Title,
Rank = message.Rank,
MessageContent = message.MessageContent,
Subverse = message.Subverse,
Likes = message.Likes,
Dislikes = message.Dislikes,
Thumbnail = message.Thumbnail,
LastEditDate = message.LastEditDate,
FlairLabel = message.FlairLabel,
FlairCss = message.FlairCss,
Anonymized = message.Anonymized,
Views = message.Views,
Comments = message.Comments,
Votingtrackers = message.Votingtrackers,
Subverses = message.Subverses,
Stickiedsubmission = message.Stickiedsubmission,
Viewstatistics = message.Viewstatistics,
ParentSet = setName
}).OrderByDescending(s => s.Date).Take(desiredResults).AsNoTracking();
return topRankedSubmissions;
}
public ProjectDocRepository()
{
_docs = _context.ProjectDocs;
_projects = _context.Projects;
_companies = _context.Companies;
_invites = _context.Invitations;
}
public StudentRepository(StuaContext context)
{
this.context = context;
studenten = context.Studenten;
stages = context.Stages;
favorietestages = context.StudentStage;
}
public OrderController()
{
_context = new OrderContext();
_dbSet = _context.Set<Order>();
_baseUri = ConfigurationManager.AppSettings["Root"] + @"/api/order/";
}
public async Task DbSetGetAsyncTest()
{
//Arrange
var mockRestResponse = new Mock<IRestResponse>();
mockRestResponse.SetupGet(o => o.ResponseStatus).Returns(ResponseStatus.Completed);
mockRestResponse.SetupGet(o => o.StatusCode).Returns(HttpStatusCode.OK);
mockRestResponse.SetupGet(o => o.Content).Returns(@"{
""contactId"": ""48620"",
""id"": ""10002"",
""fieldValues"": [
{
""id"": ""824"",
""value"": ""transxId12321321321321""
}
],
""name"": ""Test Name WHAT IS THIS"",
""uri"": ""/data/customObject""
}
");
var mockRestClient = new Mock<IRestClient>();
mockRestClient.Setup(o => o.ExecuteTaskAsync(It.IsAny<IRestRequest>())).ReturnsAsync(mockRestResponse.Object);
var dbSet = new DbSet<MockDbsetWithDataContact>(mockRestClient.Object);
//Act
var contact = await dbSet.GetAsync(1, Depth.Complete);
//Assert
Assert.AreEqual(10002, contact.Id);
}
public SettingsMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_settings = _ctx.Set<Setting>();
}
public LgEloquaContext(IRestClient restClient)
: base(restClient)
{
BadContacts = new DbSet<BadContact>(restClient);
LgContacts = new DbSet<LgContact>(restClient);
ExtendedContacts = new DbSet<ExtendedContact>(restClient);
}
public DashboardRepository(IUnitOfWork<DashboardContext> uow, ICurrentUser currentUser)
{
_context = uow.Context;
this._dbSet = _context.Set<Dashboard>();
_uow = uow;
this._currentUser = currentUser;
}
// Constructor
public BedrijfRepository(InternshipContext context)
{
this.context = context;
bedrijven = context.Bedrijven;
opdrachten = context.Opdrachten;
contactpersonen = context.ContactPersonen;
}
private void ClearDatabase(DbSet<CoffeeShop> coffeeShops)
{
foreach (var shop in coffeeShops)
{
coffeeShops.Remove(shop);
}
}
public DataProvider(Dictionary<string, string> cons) {
//Create movie context
dbConnString = cons["SqlConnString"];
db = new MoviesContext(dbConnString);
Movies = db.Movies;
}
public MenuItemRepository(IUnitOfWork<MenuItemContext> uow, ICurrentUser currentUser)
{
_context = uow.Context;
this._dbSet = _context.Set<MenuItem>();
_uow = uow;
this._currentUser = currentUser;
}
public PatronService()
{
_repository = new invoicesEntities();
_patrons = _repository.Set<Patron>();
_users = _repository.Set<User>();
_recentlyViewedPatrons = _repository.Set<RecentlyViewedPatron>();
}
public ContactRepository()
{
_conns = _context.NetworkConnections;
_reqs = _context.ConnectionRequests;
_companies = _context.Companies;
_blackLists = _context.BlackLists;
}
public PresentationRepository()
{
this.context = new UserContext();
this.dbSet = context.Set<PresentationModel>();
this.dbSetTag = context.Set<Tag>();
this.dbRatings = context.Set<RatingsModel>();
}
public InvoiceItemService()
{
_repository = new invoicesEntities();
_invoices = _repository.Set<Invoice>();
_invoiceItems = _repository.Set<InvoiceItem>();
_products = _repository.Set<Product>();
}
public BedrijfRepository(StuaContext context)
{
this.context = context;
bedrijven = context.Bedrijven;
stages = context.Stages;
bedrijfspersonen = context.Bedrijfspersonen;
}
public BegeleiderRepository(StuaContext context)
{
this.context = context;
begeleiders = context.Begeleiders;
stages = context.Stages;
studenten = context.Studenten;
}
public ComputerRepository(DbSet<ComputerModel> computers, Action save, DbSet<ScriptModel> scripts, DbSet<UserModel> users)
{
_computers = computers;
_save = save;
_scripts = scripts;
_users = users;
}
public NetworkGuestRepository(DbSet<NetworkGuestModel> entries, DbSet<NetworkModel> networks, Action save, DbSet<UserModel> users)
{
_entries = entries;
_networks = networks;
_save = save;
_users = users;
}
public static IQueryable<SetSubmission> NewestSubmissionsFromASub(string subverseName, DbSet<Submission> submissionDBSet, string setName, int desiredResults)
{
var topRankedSubmissions = (from submission in submissionDBSet
where !submission.IsDeleted && submission.Subverse == subverseName
select new SetSubmission
{
ID = submission.ID,
Votes = submission.Votes,
UserName = submission.UserName,
CreationDate = submission.CreationDate,
Type = submission.Type,
LinkDescription = submission.LinkDescription,
Title = submission.Title,
Rank = submission.Rank,
Content = submission.Content,
Subverse = submission.Subverse,
UpCount = submission.UpCount,
DownCount = submission.DownCount,
Thumbnail = submission.Thumbnail,
LastEditDate = submission.LastEditDate,
FlairLabel = submission.FlairLabel,
FlairCss = submission.FlairCss,
IsAnonymized = submission.IsAnonymized,
Views = submission.Views,
Comments = submission.Comments,
SubmissionVoteTrackers = submission.SubmissionVoteTrackers,
Subverse1 = submission.Subverse1,
StickiedSubmission = submission.StickiedSubmission,
ViewStatistics = submission.ViewStatistics,
ParentSet = setName
}).OrderByDescending(s => s.CreationDate).Take(desiredResults).AsNoTracking();
return topRankedSubmissions;
}
public PizzaController()
{
_context = new OrderContext();
_dbSet = _context.Set<Pizza>();
_baseUri = ConfigurationManager.AppSettings["Root"] + @"/api/pizza/";
}
public UnitRepository(IUnitOfWork unitOfWork, IDocRepository docRepository, IDomainValidator validator)
{
this.unitOfWork = unitOfWork;
this.docRepository = docRepository;
this.validator = validator;
unitsInContext = unitOfWork.DbContext.Set<Unit>();
}
public PersonalInfoRepository(GravityGymDbContext gravityGymDbContext, IMapper mapper) : base(gravityGymDbContext, mapper)
{
_roles = gravityGymDbContext.Roles;
}
public SessionService(Context Context)
{
context = Context;
Sessions = context.Sessions;
}
public Repository(UdemyUnitTestContext context)
{
_context = context;
_dbSet = _context.Set <TEntity>();
}
public GenericRepository()
{
db = new CrudDbContext();
this.dbSet = db.Set<T>();
}
public BranchTable(DbSet <BrancheDetail> table)
{
_table = table;
}
public UnDeleteableRepository(DbContext context)
{
Context = context;
_entities = Context.Set <TEntity>();
}
private static DbSet <Movie> Filter(DbSet <Movie> movies, _String text)
{
return(movies.Where(_ => _.Title.Contains(text) | _.Genre.Contains(text)));
}
protected void addObjectToDBSet_Insert <NameClass>(ref ConnectionEFDataFirst context, ref DbSet <NameClass> dbSetObject, List <NameClass> lsObject) where NameClass : class
{
if (lsObject != null && lsObject.Count > 0)
{
foreach (NameClass item in lsObject)
{
dbSetObject.Add(item);
}
}
}
protected void deleteListObject <NameClass>(ref ConnectionEFDataFirst context, ref DbSet <NameClass> dbSetObject, List <NameClass> lsObject) where NameClass : class
{
if (lsObject != null && lsObject.Count > 0)
{
foreach (NameClass item in lsObject)
{
dbSetObject.Attach(item);
dbSetObject.Remove(item);
}
}
}
public RoomRepository(RoomPlannerDevContext context)
{
this.context = context;
rooms = context.Set <Room>();
}
public TimeOffController(VacationDbContext context, DbSet <T> items)
{
_context = context;
_items = items;
}
protected void addObjectToDBSet_Update <NameClass>(ref ConnectionEFDataFirst context, ref DbSet <NameClass> dbSetObject, List <NameClass> lsObject) where NameClass : class
{
if (lsObject != null && lsObject.Count > 0)
{
foreach (NameClass item in lsObject)
{
dbSetObject.Add(item);
context.Entry((object)item).State = EntityState.Modified;
}
}
}
public BaseDAL(string key)
{
db = ContextFactory.GetCurrentContext(key);
dbSet = db.Set <T>();
}
public EFRoleRepository(DbContext context)
{
this.context = context;
dbSet = context.Set <Role>();
}
public Repository(ApplicationDBContext db)
{
_db = db;
this.dbSet = _db.Set <T>();
}
public BaseDAL()
{
db = ContextFactory.GetCurrentContext("zhiyin");
dbSet = db.Set <T>();
}
public FawQueryRepository(DbContext dbContext)
{
DbContext = dbContext;
Entity = DbContext.Set <TEntity>();
}
public CrudSQLRepository(AppContext context)
{
this.context = context;
this.table = context.Set<T>(); // context.Chercheur;
}
public Operations(Context context, DbSet <T> contextTable)
{
db = context;
table = contextTable;
}
public Repository(SupportContext context)
{
_context = context;
_db = context.Set <T>();
}
public Repository(ProjectContext context)
{
this.context = context;
entities = context.Set <T>();
}
public GenericRepository(DbContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public GarmentDailyPurchasingReportFacade(IServiceProvider serviceProvider, PurchasingDbContext dbContext)
{
this.serviceProvider = serviceProvider;
this.dbContext = dbContext;
this.dbSet = dbContext.Set <GarmentDeliveryOrder>();
}
internal IEnumerable <WorkingDay> GetWorkingDaysForDoctor(string doctorId)
{
return(DbSet.Where(w => w.ClinicId == doctorId).Include(w => w.DayShifts).ToList());
}
public BaseService(ObjectDbContext dbContext)
{
_dbContext = dbContext;
_dbSet = dbContext.Set <T>();
}
public Repository(DatabaseContext context)
{
_context = context;
_dbSet = context.Set <TEntity>();
}
public DataAccess(BookDBEntities context)
{
this._context = context;
this.dbSet = context.Set <TEntity>();
}
protected PaginatedRepository(DbContext c, DbSet <TData> s) : base(c, s)
{
}
protected SqlRepository(DbContext context)
{
EfDbSet = context.Set <T>();
}
public EfRepository(DbContext context)
{
_context = context;
_set = _context.Set <TEntity>();
}
