Transformations 0.0.145

Transformations Type Converter

Conversion between data types. Envisaged as a possible alternative to the Universal Type Converter http://www.codeproject.com/Articles/248440/Universal-Type-Converter, with the provision for default values, and some extra features.

Install-Package Transformations -Version 0.0.145
dotnet add package Transformations --version 0.0.145
paket add Transformations --version 0.0.145
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

* You don't need to reference the transformations namespace with Using statement (type conversions are meant to be universal if you choose to use this).

Generally you would just do:

 var newValue = oldValue.ConvertTo<newType>(optionalDefaultValue);

* You can use TryConvertTo if you need to get the result of the conversion process.

* You can do some conversions on DataTables and Lists , for example convert a data table to an object list, if the names of the columns match the object properties.

* The date conversion is set to British date format by default, not the project's current format. This may have to change to make the library more "universal".

* From some basic tests I have performed on universal type converter and this library, I found it to be a bit faster than the universal type converter...

********************************************
Some examples of use:
********************************************
string valueInput = "7F8C14B6-B3A8-4F71-8EFC-E5A7B35923B6";
Guid actual = valueInput.ConvertTo<Guid>(Guid.Empty);
// where Guid.Empty is the default value if the conversion fails.
// -----------------------------------------------
string valueInput = "0.1";
float actual = valueInput.ConvertTo<float>(0.0f);
// where 0.0f is the default value if the conversion fails.
// result = 0.1f;
// -----------------------------------------------
string valueInput = "15/02/2014";
DateTime actual = valueInput.ConvertTo<DateTime>(new DateTime(2000, 01, 01));
// where 2000-01-01 is the default value if the conversion fails.
// result = new DateTime(2014, 02, 15);
// -----------------------------------------------
float? f = 123.524f;
int? i = f.ConvertTo<int>();
// result = 124;
// -----------------------------------------------

* You can convert date to 'excel'-type value:
DateTime d = new DateTime(2005, 5, 5);
d.ToDouble();
// or d.ToInt();

List conversions examples:
// -----------------------------------------------
List<int> l1 = new List<int>(new int[] { 2, 3, 4 });
List<float> l2 = l1.ConvertToList<int, float>();
// -----------------------------------------------



**************************************************

Some additional helper methods are added as extensions as well:

// -----------------------------------------------

*Proper Case*

string name = "mr john smith";
name.ProperCase();
// result = "Mr John Smith";

// -----------------------------------------------

*Insert Spaces*

string name = "MrJohnSmith";
name.InsertSpaces();
// result = "Mr John Smith";

// -----------------------------------------------

*Remove Chars* - removes multiple instances of the same string pattern from the string.

string name = "Mr John John Smith";
name.RemoveChars("John ");
// result = "Mr Smith";

// -----------------------------------------------

*Replace Ex* - replace multiple instances of the same string pattern in the string.
string s = "12345678901234567890";
s.ReplaceEx("2", "X");
// result = "1X345678901X34567890";

// -----------------------------------------------

*Is Date* - check if string is a date! assumes en-Gb as default culture at present..

string s = "14/02/2014";
if (IsDate(s))
{ ... }
if (IsDate(s, "en-GB"))
{ ... }

// -----------------------------------------------

.ToSqlParameter() extension methods make it easier to effectively make the swift conversion to SqlParameters from most types, but please always check that the correct SqlDbType is supplied...

For example, if you wanted to supply myChar parameter to a stored procedure - a char conversion could be:

char c = 'a';
c.ToSqlParameter('myChar');
- and you would probably want to add SqlParameter to the list of parameters.

When converting a string to a varchar / nvarchar, a size of the string is required. It's usually the best practice to supply the string size to avoid runtime errors.

I'm thinking of adding a completely separate validation method to SqlParameter list, which will test that each conversion can be performed correctly.

// -----------------------------------------------


Added DataTable.HasRows()
// ie: dataTable != null && dataTable.Rows.Count > 0

Added DataRow.GetValue<T>()
- Gets the value as required type.

// -----------------------------------------------

New:

Added Some Enum extensions, eg:

YourEnum.EnumElement.ToByte()
// gives an int enum for this enum

Same applies to
[...].ToDecimal()
[...].ToDouble()
[...].ToInt()
[...].ToLong()
etc.

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
0.0.145 316 7/4/2017
0.0.144 218 5/19/2017
0.0.143 199 5/18/2017
0.0.142 216 5/16/2017
0.0.140 338 11/4/2016
0.0.139 218 11/4/2016
0.0.138 220 11/3/2016
0.0.137 214 11/3/2016
0.0.136 218 11/3/2016
0.0.135 237 11/2/2016
0.0.134 213 11/2/2016
0.0.133 219 11/2/2016
0.0.132 220 11/2/2016
0.0.131 226 11/2/2016
0.0.130 216 11/2/2016
0.0.129 374 12/14/2015
0.0.128 286 12/11/2015
0.0.127 254 12/10/2015
0.0.126 288 12/9/2015
0.0.125 276 11/20/2015
0.0.124 307 11/20/2015
0.0.123 247 11/20/2015
0.0.122 285 11/20/2015
0.0.121 245 11/20/2015
0.0.120 251 11/20/2015
0.0.119 260 11/17/2015
0.0.118 275 11/17/2015
0.0.117 251 11/17/2015
0.0.116 266 11/17/2015
0.0.115 249 11/17/2015
0.0.114 401 11/16/2015
0.0.113 243 11/16/2015
0.0.112 246 11/16/2015
0.0.111 278 11/12/2015
0.0.110 253 11/12/2015
0.0.109 264 11/3/2015
0.0.108 257 11/3/2015
0.0.107 256 11/3/2015
0.0.106 273 11/2/2015
0.0.105 253 11/2/2015
0.0.104 259 10/30/2015
0.0.103 251 10/30/2015
0.0.102 252 10/30/2015
0.0.101 262 10/30/2015
0.0.100 251 10/30/2015
0.0.99 262 10/23/2015
0.0.98 257 10/23/2015
0.0.97 265 10/19/2015
0.0.96 278 10/16/2015
0.0.95 281 10/16/2015
0.0.94 261 10/16/2015
0.0.93 258 10/16/2015
0.0.92 260 10/13/2015
0.0.91 276 10/13/2015
0.0.90 267 10/13/2015
0.0.89 298 9/16/2015
0.0.88 294 9/16/2015
0.0.87 286 8/20/2015
0.0.86 251 8/17/2015
0.0.85 256 8/6/2015
0.0.84 264 7/29/2015
0.0.83 255 7/29/2015
0.0.82 279 7/29/2015
0.0.81 261 7/28/2015
0.0.80 257 7/28/2015
0.0.79 256 7/27/2015
0.0.78 274 7/20/2015
0.0.77 342 7/20/2015
0.0.76 267 7/10/2015
0.0.75 258 7/10/2015
0.0.74 305 7/2/2015
0.0.73 275 7/2/2015
0.0.72 270 6/29/2015
0.0.71 266 6/29/2015
0.0.70 276 6/24/2015
0.0.69 275 6/23/2015
0.0.68 305 6/23/2015
0.0.67 270 6/22/2015
0.0.66 268 6/22/2015
0.0.65 285 6/5/2015
0.0.64 269 6/4/2015
0.0.63 267 6/4/2015
0.0.62 264 6/3/2015
0.0.61 270 6/2/2015
0.0.60 266 6/2/2015
0.0.59 308 6/1/2015
0.0.58 273 6/1/2015
0.0.57 334 6/1/2015
0.0.56 390 6/1/2015
0.0.55 270 5/29/2015
0.0.53 265 5/27/2015
0.0.52 255 5/27/2015
0.0.51 266 5/22/2015
0.0.50 260 5/21/2015
0.0.49 266 5/20/2015
0.0.48 266 5/20/2015
0.0.47 265 5/20/2015
0.0.46 265 5/20/2015
0.0.45 276 5/19/2015
0.0.44 266 5/19/2015
0.0.43 292 5/15/2015
0.0.42 257 5/14/2015
0.0.41 263 5/13/2015
0.0.40 276 5/12/2015
0.0.39 279 5/11/2015
0.0.38 278 5/7/2015
0.0.37 265 5/7/2015
0.0.36 258 5/7/2015
0.0.35 282 5/7/2015
0.0.34 262 5/7/2015
0.0.33 272 5/7/2015
0.0.32 264 5/6/2015
0.0.31 260 5/6/2015
0.0.30 264 5/6/2015
0.0.29 261 5/6/2015
0.0.28 260 5/6/2015
0.0.27 262 5/5/2015
0.0.26 265 5/5/2015
0.0.25 258 4/27/2015
0.0.24 275 4/24/2015
0.0.23 320 4/23/2015
0.0.22 316 4/2/2015
0.0.21 258 4/2/2015
0.0.20 275 4/1/2015
0.0.19 268 3/31/2015
0.0.18 293 3/31/2015
0.0.17 302 3/31/2015
0.0.16 277 3/31/2015
0.0.15 260 3/31/2015
0.0.14 274 3/31/2015
0.0.13 264 3/31/2015
0.0.12 263 3/30/2015
0.0.11 258 3/30/2015
0.0.10 277 3/30/2015