Read data from Azure database with C#-application, without installing a lot of applications?
-
OK, so you need to install SQL client on your system, and get the details of the database structure from the people who own it.
-
I'd recommend you to install SSMS (SQL Server Management Studio) instead.
-
No, I have access. Since this software will be run on other computers than my own, I'd like to keep 3rd party software installations/dependencies to a minimum. Ideally, all you'd have to do to run my application is to double-click an .exe-file (ideally, you should also be able to run it from a USB-stick), I don't want anybody to have to do anything more. That's why I don't use installers and instead embed all my dll:s and icons/pictures into my .exe-file, I don't like to give installation support, especially not on something I didn't write myself.
-
No, I have access. Since this software will be run on other computers than my own, I'd like to keep 3rd party software installations/dependencies to a minimum. Ideally, all you'd have to do to run my application is to double-click an .exe-file (ideally, you should also be able to run it from a USB-stick), I don't want anybody to have to do anything more. That's why I don't use installers and instead embed all my dll:s and icons/pictures into my .exe-file, I don't like to give installation support, especially not on something I didn't write myself.
-
No, I have access. Since this software will be run on other computers than my own, I'd like to keep 3rd party software installations/dependencies to a minimum. Ideally, all you'd have to do to run my application is to double-click an .exe-file (ideally, you should also be able to run it from a USB-stick), I don't want anybody to have to do anything more. That's why I don't use installers and instead embed all my dll:s and icons/pictures into my .exe-file, I don't like to give installation support, especially not on something I didn't write myself.
Wait you already have an application that will consume the data! Why don't you modify your app to query the database?
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Wait you already have an application that will consume the data! Why don't you modify your app to query the database?
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Then write the database query into your application like every other developer does.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
I am writing a C# application in Visual Studio 2005 and I need to read, but NOT write, data inside an Azure database and I would like to install as few applications on my computer as possible. It would also be nice if I could simply spend a couple of minutes copying the whole database file to my computer upon startup and from then on access the data completely locally. There is no requirement that I should access the data I want through SQL-queries, if it's feasible to iterate through the database file with while-loops, if-statements, etc that would be perfectly fine with me. Is this feasible or what's the minimum I can get away with?
I found a really great tool where I can browse for an .mdf-file and select it and then see the tables with all the data. It's called "SysInfoTools SQL File Viewer v18.0" and it's only a few megabytes large. After I have installed it, I can see a file called "Script Instruction.txt" in the installation folder with the following contents: "********************************************************************** Information about script ********************************************************************** Mainsqlscript.bat is our main script File, which contains path information of all the tables, views, stored procedure, triggers, functions,etc. Script file with database name “Databasename”.sql File contains script for creation of Database. Tables Folder Contain Script of all the tables. StoreProcedure Folder Contain script file for every Procedure. Triggers Folder Contain script file for every Trigger. Views Folder Contain script file for every view. Functions Folder Contain script file for every function. altertablecommandPrimarykeys contain script file for every primarykey. Altertablecommandforeignkeys contain script file for every foreign key. ********************************************************************** How to run Script ********************************************************************** 1. Open Command prompt. Cmd.exe with run as Administrator. 2. Move to Batch file path using command cd "Path of batch file" 3. Type Command mainsqlscript.bat NOTE: If the given Database name already exist in sql server instance then old database will be deleted and new database with the given name is created. Server Name and Database Name are compulsary parameters for running script." Does anybody understand what they mean by the above, does it mean that I can run it from a standard .bat-file (the ones that were invented by Microsoft in the 80's) and not have to see the GUI show up?