...All those moments will be lost in time, like tears in rain....

- soliloquy from Blade Runner

Bits and bytes do get lost, awash in the rain of data flow that is Internet. They slip away from us, never to found again... some of them will be captured here, many more will not... like tears in rain...

Thursday, January 24, 2013

Hyphens, dash - dash, hyphens!

As a non native English speaker, I am happy when I am able to unravel another mystery from the language :) In this case, 3 different "dash" signs in the written English :)

-            hyphen
–           n-dash
 (also known as ndash or en-dash)
—         m-dash
 (also known as mdash or em-dash)

Hyphen is what we are using when words wrap at the end of a line. Other use is for the phone numbers, things that are grouped together, but not by range.

n-dash is used for ranges, either words or numbers.

m-dash is used when the sentence is going into another direction and other part of the sentence is radially different. Also, it can be used when dialog is being interrupted.

 How I got here? Html entities and correct display of those on the web page...

Here they are:


 0. The soft hyphen (­ a.k.a. “discretionary hyphen” and “optional hyphen”) is to be used for one purpose only—to indicate where a word may be broken at the end of a line.
 1. The non-breaking hyphen (‑ not in HTML) does just what its name implies.
 2. The hyphen character (‐ not in HTML) is meant to be used in place of the hyphen-minus when a hyphen is exactly the desired character.
 3. The hyphenation point (‧ not in HTML) is that bullet-like character you find in some dictionaries to separate syllables.

The en dash:  (–)

The em dash: (—)

Monday, January 14, 2013

Datasets and timeouts

When using tableadapter to retrieve the data from database, Microsoft did not provide property to set command timeout anywhere, unless you go to generated file directly.
 Once in XDataSet.Designer.cs file, there are 2 places that Command Timeout can be set:
1) On SelectCommand of Adapter itself  - if this is for data retrieval calls, GetData method:
this.Adapter.SelectCommand.CommandTimeout = 60;
2) On initialization of command collection - each stored procedure call can have it's own command timeout.
 this._commandCollection[0].CommandTimeout = 60;

 By default, no timeout is set, and default is 30 seconds.