Hi Robert, Team, and all X# community- friends and colleagues,
I returned from the great conference in Cologne to get my home office desktop computer system all up to date and 'clean', and sorted out.
You may remember that I had used the VS 2017 Installer app too many times on all three versions, and I seemed to have broken it all - the VS installer.
So then, with a new Beta version of X# in my hands, and the fact that I could make big changes to my system after the Conference, I got to work.
My plan was to make a Virtual Machine using 'Hyper-V' and then to only install on this VM the latest SQL Server, Visual Studio 2017, and also the latest X#. I was also to install Management Studio so I could help Michael and others with going to SQL with X#.
Well, after some hard work, and trial and error etc., I did eventually get a VM based on Windows 10 x64 and my VM could communicate with the Internet to allow me to install things in the modern usual way, via downloads (directly).
Okay then guys, what of my successes and failures ?
Success :- I have Visual Studio 2017 Professional installed and working. I have SQL Server 2016 (update 1) and the advanced tools (includes Management Studio). And finally I downloaded and installed the latest X# compiler into my VM platform.
Failure :- Any X# project I start (all as simple defaults) give me an error which restarts VS - a crash-out. The apps don't run after the restart.
The C# forms of the console, WinForms, and WPF all compile and run - which checks out my VS 2017 install.
So my questions are :- does the new VS2017 run apps outside of a Virtual Machine (remember I can't test this as my Installer is broken on the standard Win 10 O/S) without issue ?
Has anyone else got a Windows 10 VM running VS 2017 and X# ?
Any thoughts ? Any other tests I can do ?
I include one image of the many I took while setting up my VM. Oh! and soon I will make a small CHM set of eNotes to help any others who wish to make a VM, as it should prove very useful to X# work generally I feel.
This may be relevant for your issue. I run a copy of Win 10 as a virtual machine under VM Ware. Have VS 2015 installed along with X#. Put on Beta 11 and got crashes after template selection or trying to open X# projects.
Turns out I had the VM set to run with one core. Changed it to two core and it ran like a dream.
Many thanks to Robert for his help on this. I thought I would be the only one to fall into this trap, but thinking about it, anybody running VMs could be affected.
the queries are executing with the same results. The 1. query is pretty easy to understand and by "examing" the second one I think it all makes sense. Challenge mostlikely will be to build such a query.
From your perspective: is it a must to fully understand SQL Query Building or do we do this in X#? I am asking as I might need to learn much more about SQL queries and a good book could help. If we do this with X# I will delay my query appetite for later.