Profile cover photo
Profile photo
Måns Tånneryd
23 followers
23 followers
About
Posts

Post has attachment
Speeding up inserts using the Entity Framework - Part 5 (EF 6.1)
The entity framework is not particularly well adapted to inserting large amounts of data. It encapsulates every single insert statement in its own stored procedure call sending them one at a time to the database server. It takes a very long time if you have...
Add a comment...

Post has attachment
Managing indexes for foreign keys
Having an index for every foreign key is usually a good thing. If you need to figure out if you have any this script might help you out. It finds all existing indexes for foreign keys and creates drop statements for them. It also creates index create statem...
Add a comment...

Post has attachment
Deserializing XML in .NET
At first glance it seems reasonable that the following XML would be nicely deserialized into the .NET class below. <? xml version ="1.0" encoding ="UTF-8" ? > < GetTicketHTTPResponse > < ticket > b99a2231-c0a8-0c21-7dd8-76fde0745043 </ ticket > < expires > ...
Add a comment...

Post has attachment
Mulitple profiles in AnyConnect drop down list
Add the following to the file AnnyConnectProfile.xml in directory  "%ProgramData%\Cisco\Cisco AnyConnect Secure Mobility Client\Profile" to get multiple hosts to choose from in your AnyConnect drop down list. <?xml version="1.0" encoding="UTF-8"?> <AnyConne...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Declaring a list variable in SQL
DECLARE @Vowels TABLE (ColumnName CHAR(1)) INSERT INTO @Vowels VALUES ('a') INSERT INTO @Vowels VALUES ('e') INSERT INTO @Vowels VALUES ('i') INSERT INTO @Vowels VALUES ('o') INSERT INTO @Vowels VALUES ('u') INSERT INTO @Vowels VALUES ('y') INSERT INTO @Vow...
Add a comment...

Post has attachment
Interesting reads
The purpose of this blog post is to help me remember interesting articles. http://www.fastcompany.com/51733/fabric-creativity
Add a comment...

Post has attachment
Using a DateTimePicker in a BindingNavigators ToolStrip, or any other ToolStrip I assume
There is a dropdown menu in the binding navigator toolstrip (Windows Forms) where you can insert various controls. The DateTimePicker is not one of them though but that can be easily fixed. All you need to do is to add something like the following in your f...
Add a comment...

Post has attachment
Speeding up inserts using Linq-To-Entities - Part 4 (EF 6.1)
This is yet another post about speeding up inserts using the entity framework. Previously I have written about this in the following posts. Speeding up inserts using Linq-To-Entities - Part 3 Speeding up inserts using Linq-To-Entities - Part 2 Speeding up i...
Add a comment...

Post has attachment
Speeding up inserts using Linq-To-Entities - Part 3 (EF 6.1)
This is yet another post about speeding up inserts using the entity framework. Previously I have written about this in the following posts. Speeding up inserts using Linq-To-Entities - Part 3 Speeding up inserts using Linq-To-Entities - Part 2 Speeding up i...
Add a comment...
Wait while more posts are being loaded