Last post Dec 04, 2014 05:39 PM by rrrsr7205
Dec 04, 2014 04:35 PM|wavemaster|LINK
Little bit under time pressure here, need to get this VS stuff down quick.
I am familiar with VS and the debugger functionality, but I am lost with the db side of things.
First of all why doesn't VS open the sdf when I open my site? Is there a setting I need to get?
Second, I really like how WebMatrix let's you view the changes and make selections on why you are going to publish including the db. Is there similar functionality in VS?
Now, it publishes everything including the SQL CE db when I hit publish. I don't want that!
Mods, I realize there are probably other forums this should go in, but when I post there I am likely to get blank stares, well at least the forum equivalent.
Dec 04, 2014 04:49 PM|Mikesdotnetting|LINK
VS 2013 doesn't provide any tooling for SQL CE databases. If you have the full version of VS, you can add SqlCE toolbox. Go to Tools » Extensions and search for SQL CE.
I publish to the local file system and use FTP to deploy sites. Once you have created a Profile, you can choose to exclude files from App_Data in the File Publishing Options (Settings).
Dec 04, 2014 05:00 PM|wavemaster|LINK
I have downloaded VS2012 Ultimate, was using 2013 Ultimate before but I could not get add a connection to the db.
What do you mean with "publish to the local file system? I am already opening from the local file system and then saving.
Looks like I need to get some sort of Azure plug in or so.
One more... is there something in VS where you can type in a query just like in WM?
Dec 04, 2014 05:26 PM|Mikesdotnetting|LINK
I usually precompile Web Site projects which is the only reason for publishing them in my view. I don't use anything in VS to get the site files up to a web server. I use FileZilla for that. Creature of habit.
VS 2012 provides tooling for sdf files. Go to Server Explorer (Ctrl+Alt+S) and add a new connection. Once you have done that, right click on the database and choose the New Query option.
Dec 04, 2014 05:39 PM|rrrsr7205|LINK
I am using Visual Studio Comunity Edition (basically, it is VS Professional but for free) and I had previously installed the SQL Server Compact Toolbox for Runtime 4.0 (https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1?SRC=VSIDE)
on my pc.
In VS Community Edition 2013, I am able to right click on the sdf files in the App_Data folder and open it up with the SS Compact Toolbox.
I also found an extension online (In the VS Tools menu, "Extensions and Updates") -search for "sql server compact toolbox" . That should help you out