localdb Questions
2
Solved
I've been using (localdb)\ProjectsV13 as part of my VS 2017 installation, however, I recently needed to access some SQL Server 2017 features during development, so I installed SQL Server 2017 Local...
Messenia asked 23/3, 2018 at 21:33
4
Solved
On my machine MSSQLLocalDB got corrupted:
PS C:\WINDOWS\system32> sqllocaldb i
MSSQLLocalDB
Projects
ProjectsV12
v11.0
PS C:\WINDOWS\system32> sqllocaldb i mssqllocaldb
The required L...
Lowminded asked 9/11, 2015 at 5:26
2
Solved
Is There any way to RESEED a LocalDB Table using EF?
I'd prefer not to use this SQL Command :
DBCC CHECKIDENT('TableName', RESEED, 0)
FYI : I'm using EF 6.1.
Thanks alot.
Missioner asked 2/10, 2014 at 7:4
2
Solved
I'm trying to deploy a DACPAC to LocalDB 2012 but it's just not having it:
Stack trace is as follows:
==================================
Could not deploy package. (Microsoft.SqlServer.Dac)
----...
Desiccant asked 12/3, 2016 at 0:3
5
Solved
When I try to run my ASP.NET MVC 4 application using Local IIS on Windows 7 with Visual Studio 2013. I run into the following error when the application tries to connect to localDB\v11.0
Server ...
5
Solved
I am trying to construct a connection string to a 2008 SQL Express database file in VS 2012. I am getting an error dialog:
This database file is not compatible with the current instance of SQL
...
Shaffert asked 14/3, 2013 at 18:35
4
Solved
If I have to work with localdb, do we need to install it separately?
I have SQL Server 2008 R2 Management Studio installed, SQL Server 2012 installed, .net 4.0.2 update installed. But I don't see ...
Boil asked 27/4, 2014 at 6:9
19
Solved
In my Win 7 development machine, and in order to use SQL Express instance instead of the localDB installed by default. I unchecked "Use IIS Express" in my MVC 4 project properties page (Web tab), t...
Westfalen asked 6/12, 2012 at 17:27
3
Per MSDN Docs: http://msdn.microsoft.com/en-us/library/hh510202.aspx
LocalDB supports two kinds of instances: Automatic instances and Named instances.
I suspect this has something to do with my p...
Aphrodisiac asked 20/12, 2014 at 6:26
2
Solved
Apparently, using AttachDbFilename and user instance in your connection string is a bad way to connect to a DB. I'm using SQL server express on my local machine and it all seems to work fine. But w...
Crossbreed asked 24/6, 2012 at 15:34
1
Solved
Context
I'm working on a desktop app which must be able to run in case of connection loss with the distant sql server : a SQL Server Express (I know...) 2012. I'm working on Visual Studio Express ...
Apiarian asked 19/12, 2014 at 10:40
1
Solved
We are deploying to MS SQL Server localdb for integration testing.
We build a Database Project and the resulting dacpac file is copied in order to be used by the IntegrationTests project. So far w...
Deportation asked 12/4, 2017 at 9:23
2
Solved
I've got a large SQL script (1gb) that I'm trying to run against a (localdb)\v11.0 instance, using SqlCmd in a command line window, but so far no commands I've tried have worked with it at all.
E....
Adhere asked 7/7, 2015 at 13:4
1
Solved
According to this answer, SQL Server Data Tools uses a private LocalDB instance ProjectsV13, which you're not supposed to use for your own applications. Instead, you should use MSSQLLocalDB or your...
Tagliatelle asked 4/4, 2017 at 15:9
1
Solved
I'm trying to create backup and restore functionality to my Windows form application.
So, I've tried to do a database restore. My code is like this:
string cbdfilename = "c:\\Users\\Public\\Publ...
Eight asked 17/2, 2017 at 21:17
2
Solved
I'm trying to replicate a production environment locally and the production database uses a linked server. I've been able to create multiple instances of localdb; is it possible to create a linkeds...
Cambrai asked 22/11, 2016 at 16:34
1
So i have a localdb set up for my project in Visual Studio but when I publish it to my Azure web app, I get "
An unhandled exception occurred while processing the request. Win32Exception: The sy...
Emergency asked 6/2, 2017 at 4:33
1
Solved
I am having quite a few problems understanding differences between regular SQL Server Express and express Localdb.
Before you go ahead and tag a previous post about this question, I've went throug...
Graeco asked 3/2, 2017 at 15:57
1
My application uses a LocalDb instance to store it's data. I've noticed a quirk in the way that LocalDb has allocated identifies (explained more here) which I'd like to avoid. The linked answer exp...
Hearn asked 19/8, 2016 at 16:37
3
Solved
I know that using LocalDb is very good and easy for developement, I wonder if it's good idea to use it in production when I host websites on IIS server?
I'm asking because I wonder if it won't hav...
Yellowhammer asked 26/11, 2012 at 19:1
3
I recently installed VS2015 Update 2 on two different PC, one at home and one at work, with the same installer file.
Now if I open a project with Sql LocalDB on my own PC, I obtain this error:
...
Firetrap asked 18/4, 2016 at 16:18
5
I've configured an .mdf file along with a localdb connection string for use in unit tests, like this:
<connectionStrings>
<add name="TestData" providerName="System.Data.SqlClient" connec...
Tarpaulin asked 5/9, 2012 at 2:4
2
Solved
Our application uses SQL Server LocalDb 2014 as the database engine. The connection string we use is
"Data Source=(localdb)\MSSQLLOCALDB;Initial Catalog=OurDatabase;MultipleActiveResultSets=True;...
Nickels asked 11/10, 2016 at 9:21
4
Solved
I've been using a localDB named 'Projects' for a while now. This is the same database that is created by default ASP.NET MVC 5 project. However, suddenly it stopped and I'm not able to connect to i...
Wolfsbane asked 24/9, 2014 at 3:11
8
I'm trying to do the Code First Walkthrough of the entity framework ( http://blogs.msdn.com/b/adonet/archive/2011/09/28/ef-4-2-code-first-walkthrough.aspx ).
I have the latest SQL Server Express a...
Ectoderm asked 10/5, 2012 at 18:51
© 2022 - 2024 — McMap. All rights reserved.