I know it’s totally dorky, but I just make sure that the slash is parallel to the first part of the “v”. My little secret to get the back slash correct is visual: Here’s a blog post from 2006 as evidence! So connecting to localdb is always a challenge because you specify it as (localdb)\v11.0. I have always had a problem remembering forward slash vs. Oh and one more trick for you about localdb And I always spend hours trying to do it in a way that it’s really simple for the dev who is trying out my sample solution. I’ve used SQL Express, SQL CE, database scripts, packaged exes, you name it. I’m perennially looking for a simpler way to do this. It was important to me because I need to distribute sample solutions along with existing databases and I want the database files in the solution folder and *simple* steps I could relay to users to make sure they could use them when they want to debug and test out the solution themselves. Just “duh” for how much time I spent on this.
Once it was attached to localdb, then I could see it in SSOE and actually access it in my app using a normal connection string. I couldn’t figure out how to attach to an existing database.įinally, some brain cells returned to my skull and I went over to VS’s Server Explorer and attached the database there (and provided a nice logical name rather than ending up with the rangy file-path-as-database-name). SSOE lets you inspect databases that are already attached to localdb and it lets you create new localdb databases. SSOE covers many (not all) common tasks…and many more than VS’s Server Explorer let’s you do.īut I spent an embarrassing amount of time trying to figure out how to easily connect an MDF file to my SQL Server 2012 LocalDB instance because, duh …I was doing it wrong! Over and over and over again.
I’ve been loving Visual Studio 2012’s SQL Server Object Explorer (SSOE) instead of always jumping out to SQL Server Management Studio (SSMS) to do database management.
0 kommentar(er)
