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 293 7/4/2017
0.0.144 202 5/19/2017
0.0.143 184 5/18/2017
0.0.142 201 5/16/2017
0.0.140 320 11/4/2016
0.0.139 199 11/4/2016
0.0.138 202 11/3/2016
0.0.137 195 11/3/2016
0.0.136 199 11/3/2016
0.0.135 218 11/2/2016
0.0.134 194 11/2/2016
0.0.133 199 11/2/2016
0.0.132 201 11/2/2016
0.0.131 209 11/2/2016
0.0.130 197 11/2/2016
0.0.129 355 12/14/2015
0.0.128 265 12/11/2015
0.0.127 235 12/10/2015
0.0.126 267 12/9/2015
0.0.125 257 11/20/2015
0.0.124 289 11/20/2015
0.0.123 228 11/20/2015
0.0.122 265 11/20/2015
0.0.121 227 11/20/2015
0.0.120 232 11/20/2015
0.0.119 241 11/17/2015
0.0.118 255 11/17/2015
0.0.117 232 11/17/2015
0.0.116 246 11/17/2015
0.0.115 230 11/17/2015
0.0.114 374 11/16/2015
0.0.113 224 11/16/2015
0.0.112 227 11/16/2015
0.0.111 259 11/12/2015
0.0.110 235 11/12/2015
0.0.109 245 11/3/2015
0.0.108 238 11/3/2015
0.0.107 237 11/3/2015
0.0.106 254 11/2/2015
0.0.105 234 11/2/2015
0.0.104 240 10/30/2015
0.0.103 234 10/30/2015
0.0.102 233 10/30/2015
0.0.101 245 10/30/2015
0.0.100 232 10/30/2015
0.0.99 243 10/23/2015
0.0.98 238 10/23/2015
0.0.97 247 10/19/2015
0.0.96 258 10/16/2015
0.0.95 261 10/16/2015
0.0.94 242 10/16/2015
0.0.93 239 10/16/2015
0.0.92 243 10/13/2015
0.0.91 256 10/13/2015
0.0.90 249 10/13/2015
0.0.89 276 9/16/2015
0.0.88 274 9/16/2015
0.0.87 267 8/20/2015
0.0.86 234 8/17/2015
0.0.85 237 8/6/2015
0.0.84 245 7/29/2015
0.0.83 236 7/29/2015
0.0.82 259 7/29/2015
0.0.81 242 7/28/2015
0.0.80 238 7/28/2015
0.0.79 236 7/27/2015
0.0.78 255 7/20/2015
0.0.77 322 7/20/2015
0.0.76 246 7/10/2015
0.0.75 241 7/10/2015
0.0.74 286 7/2/2015
0.0.73 256 7/2/2015
0.0.72 254 6/29/2015
0.0.71 249 6/29/2015
0.0.70 257 6/24/2015
0.0.69 254 6/23/2015
0.0.68 285 6/23/2015
0.0.67 251 6/22/2015
0.0.66 249 6/22/2015
0.0.65 268 6/5/2015
0.0.64 250 6/4/2015
0.0.63 248 6/4/2015
0.0.62 245 6/3/2015
0.0.61 251 6/2/2015
0.0.60 247 6/2/2015
0.0.59 287 6/1/2015
0.0.58 254 6/1/2015
0.0.57 312 6/1/2015
0.0.56 366 6/1/2015
0.0.55 250 5/29/2015
0.0.53 247 5/27/2015
0.0.52 237 5/27/2015
0.0.51 247 5/22/2015
0.0.50 241 5/21/2015
0.0.49 247 5/20/2015
0.0.48 247 5/20/2015
0.0.47 244 5/20/2015
0.0.46 246 5/20/2015
0.0.45 255 5/19/2015
0.0.44 247 5/19/2015
0.0.43 272 5/15/2015
0.0.42 239 5/14/2015
0.0.41 244 5/13/2015
0.0.40 257 5/12/2015
0.0.39 259 5/11/2015
0.0.38 258 5/7/2015
0.0.37 246 5/7/2015
0.0.36 239 5/7/2015
0.0.35 262 5/7/2015
0.0.34 243 5/7/2015
0.0.33 251 5/7/2015
0.0.32 245 5/6/2015
0.0.31 241 5/6/2015
0.0.30 245 5/6/2015
0.0.29 242 5/6/2015
0.0.28 241 5/6/2015
0.0.27 243 5/5/2015
0.0.26 244 5/5/2015
0.0.25 239 4/27/2015
0.0.24 255 4/24/2015
0.0.23 298 4/23/2015
0.0.22 288 4/2/2015
0.0.21 239 4/2/2015
0.0.20 255 4/1/2015
0.0.19 248 3/31/2015
0.0.18 274 3/31/2015
0.0.17 282 3/31/2015
0.0.16 256 3/31/2015
0.0.15 241 3/31/2015
0.0.14 254 3/31/2015
0.0.13 243 3/31/2015
0.0.12 244 3/30/2015
0.0.11 239 3/30/2015
0.0.10 258 3/30/2015