This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have been using Linqpad against my lightspeed model for a while. However Linqpad has now stopped working.
When I try to run a query, I get the following error: Normal 0 false false false EN-NZ X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} System.IO.FileNotFoundException: Could not load file or assembly 'AWSSDK, Version=1.0.7.0, Culture=neutral, PublicKeyToken=cd2d24cd2bace800' or one of its dependencies. The system cannot find the file specified.
at
at
at
I suspect that this may have something to do with using linked models. IIRC when I added a new model it defaulted to AmazonSimpleDB. However I can't find any traces of AmazonSimpleDB or awssdk now. My model still works fine inside my app though. Any ideas?
Sean
|
|
|
|
|
Check the LinqPad connection properties. If you create a LinqPad connection from a .lsmodel file, it tries to guess the database and connection string from the .lsmodel file, but this is a one-off thing -- it doesn't track changes to the .lsmodel. So if you created the connection when the .lsmodel was defaulting to AmazonSimpleDB then that was probably how the LinqPad connection got created. Just open the connection properties dialog and update it with the correct data provider and connection string. |
|
|
|
|
My connection string was correct, and I had the DatabaseProvider set to SqlServer2008. I changed it to SqlServer2005 and everything started working. Changed it back to SqlServer2008 and it was broken again. I am happy now now I have it working.
Sean
|
|
|
|
|
Thanks for the additional info. I think I know what that bug is and I'll get it fixed in a future release. |
|
|
|
