Keept getting errormessages like the following
C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Common.CurrentVersion.targets(1819,5):
Could not resolve this reference.
Could not locate the assembly "Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL".
Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors.
Turns out there is a simpler solution than installing Visual Studio on the build-server.
there is a nuget package that resolves this error
PM> Install-Package Microsoft.VisualStudio.QualityTools.UnitTestFramework.Updated
VisualStudio 2012 assumes we are using the latest and greatest (version 2) when it comes to the Razer view engine. However when we are opening a project that was created using version 2010 then we were using 1.0 and that is the reason that 2012 is telling us about all the errors it believes we have with our project.
The solution is to edit the web.config file and under “appSettings” tell VisualStudio that this project is using version 1.0
<add key="webpages:Version" value="1.0" />
In order to store Binary data in a table, all that is needed is to upload the bytes from the file, one way to do this is to use File.ReadAllBytes
Dim fileName As String = "C:\testfile.txt"
dbCommand = New SqlCommand("UPDATE FileTable SET BinaryFile=@BinaryFile WHERE FileId = @FileId", dbConnection)