FAQ Database Discussion Community


Using Microsoft Sync Framework for Multiple Offline (LAN-Connected) Local Databases?

sql-server,winforms,microsoft-sync-framework,localdb,data-synchronization
I have several computers which, in their production environment, will only be connected to each other via LAN. There will be no Internet connection. Each computer is going to start off with an identical copy of an application with a local database. As the application is used on each computer,...

Insert will not insert anything [closed]

c#,asp.net,sql-server,sqlconnection,localdb
I am building a application for library management in ASP.NET webforms and I have a form that should add new Users to the database. But when I try to submit it the page will just flash and nothing is added to the db. Here is the aspx code: <div style="margin-top:...

How to start using EF code first migrations on an existing set of databases whilst also using LocalDB for testing

entity-framework,code-first-migrations,localdb
I am working on a system that currently has a number of environments (test, stage, live, etc) each with their own database. So far these databases have been kept in sync by running the same update scripts on each of them. We are now moving to using EF6 code first...

C# entity framework MVC second run error

entity-framework,asp.net-mvc-4,localdb
I am creating db and initializing data with code below, if DB doesnt exist, it creates db and populate it, when I run application second time I get error Cannot drop database "aspnet-app" because it is currently in use. Application_start, with initializations protected void Application_Start() { AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes);...

c# to vb using Sync Framework strange error

c#,sql-server,vb.net,microsoft-sync-framework,localdb
I followed Microsoft's walkthrough for Sync Framework which is written in C#. And I wish to translate it to VB. I have simplified the code as much as possible. Both codes compile fine. They are running under 2 projects within the same solution. C# runs fine, but VB gives the...