Transformations 0.0.145

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
<PackageReference Include="Transformations" Version="0.0.145" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
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.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
0.0.145 1,773 7/4/2017
0.0.144 1,660 5/19/2017
0.0.143 1,657 5/18/2017
0.0.142 1,671 5/16/2017
0.0.140 1,796 11/4/2016
0.0.139 1,670 11/4/2016
0.0.138 1,658 11/3/2016
0.0.137 1,659 11/3/2016
0.0.136 1,665 11/3/2016
0.0.135 1,681 11/2/2016
0.0.134 1,653 11/2/2016
0.0.133 1,659 11/2/2016
0.0.132 1,661 11/2/2016
0.0.131 1,676 11/2/2016
0.0.130 1,659 11/2/2016
0.0.129 1,824 12/14/2015
0.0.128 1,741 12/11/2015
0.0.127 1,709 12/10/2015
0.0.126 1,806 12/9/2015
0.0.125 1,730 11/20/2015
0.0.124 1,769 11/20/2015
0.0.123 1,691 11/20/2015
0.0.122 1,737 11/20/2015
0.0.121 1,694 11/20/2015
0.0.120 1,699 11/20/2015
0.0.119 1,712 11/17/2015
0.0.118 1,728 11/17/2015
0.0.117 1,705 11/17/2015
0.0.116 1,710 11/17/2015
0.0.115 1,693 11/17/2015
0.0.114 1,854 11/16/2015
0.0.113 1,679 11/16/2015
0.0.112 1,697 11/16/2015
0.0.111 1,723 11/12/2015
0.0.110 1,693 11/12/2015
0.0.109 1,719 11/3/2015
0.0.108 1,712 11/3/2015
0.0.107 1,711 11/3/2015
0.0.106 1,726 11/2/2015
0.0.105 1,696 11/2/2015
0.0.104 1,699 10/30/2015
0.0.103 1,701 10/30/2015
0.0.102 1,692 10/30/2015
0.0.101 1,705 10/30/2015
0.0.100 1,706 10/30/2015
0.0.99 1,718 10/23/2015
0.0.98 1,705 10/23/2015
0.0.97 1,713 10/19/2015
0.0.96 1,723 10/16/2015
0.0.95 1,734 10/16/2015
0.0.94 1,712 10/16/2015
0.0.93 1,704 10/16/2015
0.0.92 1,715 10/13/2015
0.0.91 1,729 10/13/2015
0.0.90 1,716 10/13/2015
0.0.89 1,750 9/16/2015
0.0.88 1,734 9/16/2015
0.0.87 1,733 8/20/2015
0.0.86 1,703 8/17/2015
0.0.85 1,701 8/6/2015
0.0.84 1,708 7/29/2015
0.0.83 1,701 7/29/2015
0.0.82 1,724 7/29/2015
0.0.81 1,703 7/28/2015
0.0.80 1,706 7/28/2015
0.0.79 1,703 7/27/2015
0.0.78 1,726 7/20/2015
0.0.77 1,788 7/20/2015
0.0.76 1,718 7/10/2015
0.0.75 1,700 7/10/2015
0.0.74 1,748 7/2/2015
0.0.73 1,725 7/2/2015
0.0.72 1,717 6/29/2015
0.0.71 1,708 6/29/2015
0.0.70 1,710 6/24/2015
0.0.69 1,723 6/23/2015
0.0.68 1,758 6/23/2015
0.0.67 1,712 6/22/2015
0.0.66 1,719 6/22/2015
0.0.65 1,732 6/5/2015
0.0.64 1,721 6/4/2015
0.0.63 1,711 6/4/2015
0.0.62 1,719 6/3/2015
0.0.61 1,725 6/2/2015
0.0.60 1,715 6/2/2015
0.0.59 1,763 6/1/2015
0.0.58 1,716 6/1/2015
0.0.57 1,777 6/1/2015
0.0.56 1,831 6/1/2015
0.0.55 1,713 5/29/2015
0.0.53 1,704 5/27/2015
0.0.52 1,700 5/27/2015
0.0.51 1,711 5/22/2015
0.0.50 1,709 5/21/2015
0.0.49 1,711 5/20/2015
0.0.48 1,712 5/20/2015
0.0.47 1,746 5/20/2015
0.0.46 1,717 5/20/2015
0.0.45 1,720 5/19/2015
0.0.44 1,717 5/19/2015
0.0.43 1,734 5/15/2015
0.0.42 1,705 5/14/2015
0.0.41 1,715 5/13/2015
0.0.40 1,727 5/12/2015
0.0.39 1,727 5/11/2015
0.0.38 1,728 5/7/2015
0.0.37 1,720 5/7/2015
0.0.36 1,710 5/7/2015
0.0.35 1,728 5/7/2015
0.0.34 1,709 5/7/2015
0.0.33 1,722 5/7/2015
0.0.32 1,716 5/6/2015
0.0.31 1,692 5/6/2015
0.0.30 1,701 5/6/2015
0.0.29 1,708 5/6/2015
0.0.28 1,707 5/6/2015
0.0.27 1,706 5/5/2015
0.0.26 1,711 5/5/2015
0.0.25 1,702 4/27/2015
0.0.24 1,722 4/24/2015
0.0.23 1,766 4/23/2015
0.0.22 1,766 4/2/2015
0.0.21 1,704 4/2/2015
0.0.20 1,715 4/1/2015
0.0.19 1,717 3/31/2015
0.0.18 1,738 3/31/2015
0.0.17 1,745 3/31/2015
0.0.16 1,720 3/31/2015
0.0.15 1,694 3/31/2015
0.0.14 1,725 3/31/2015
0.0.13 1,698 3/31/2015
0.0.12 1,706 3/30/2015
0.0.11 1,709 3/30/2015
0.0.10 1,721 3/30/2015