October 25th, 2012 10:58 PM
If not every student has a location, why don't you just allow that property to be nullable, or have a default value?
October 25th, 2012 03:24 PM
Have an application that needs to read and analyse numerous text files. Each file will only be about the length of a chapter in a book. I am using StreamReader to load the text. Each text will be...
October 25th, 2012 03:10 PM
If you read a file as a stream, it can be as large as you like. I searched for a size limit to MS SQL's nvarchar, and couldn't find one.
When it comes to displaying your text, you will be...
October 2nd, 2010 07:44 AM
I switched to using TableAdapterManager.UpdateAll(), which wraps the changes in a transaction. However it is still very slow.
490 rows took 3 minutes, 4 seconds to update.
Is there anything...
September 28th, 2010 11:32 AM
Thanks for the reply, TechGnome. I will try your suggestion and post back.
I was opening and closing it like that to try to prevent the transaction from being promoted to DTC, though as you can...
September 26th, 2010 08:33 AM
I am developing a .NET 4.0 application that connects to a remote MS SQL database.
Calling tableAdapter.Update() on each table is very slow. From what I have read on the Internet, updating the...