WinForms controls to develop with the Pfz.Databasing framework

using System;
using System.Data;
using System.Reflection;
using Pfz.Extensions.AttributeExtensions;
using Pfz.Databasing.Managers;

namespace Pfz.Databasing.DataTypeConverters
{
	/// <summary>
	/// Converts String values to and from database.
	/// </summary>
	public sealed class StringConverter:
		BaseDataTypeConverter
	{
		/// <summary>
		/// false.
		/// </summary>
		public override bool CanParseSubTypes
		{
			get
			{
				return false;
			}
		}

		/// <summary>
		/// typeof(String)
		/// </summary>
		public override Type CSharpType
		{
			get
			{
				return typeof(String);
			}
		}
		
		/// <summary>
		/// DbType.String.
		/// </summary>
		public override DbType GetDbType(LocalDatabaseManager manager, IDatabaseConnection connection, Type type)
		{
			return DbType.String;
		}
		
		/// <summary>
		/// Convert.ToString.
		/// </summary>
		public override object ConvertFromDatabase(LocalDatabaseManager manager, IDatabaseConnection connection, PropertyInfo propertyInfo, object databaseValue)
		{
			return Convert.ToString(databaseValue);
		}

		/// <summary>
		/// Does nothing.
		/// </summary>
		public override object ConvertToDatabase(LocalDatabaseManager manager, IDatabaseConnection connection, PropertyInfo propertyInfo, object value)
		{
			if (object.Equals(string.Empty, value))
				return DBNull.Value;
				
			return value;
		}

		/// <summary>
		/// If the property contains the [DatabaseLength] attribute, and it is
		/// 1, returns CHAR.
		/// Else, returns varchar (or the length from database length, or 255).
		/// </summary>
		public override string GetCreateSqlTypeString(LocalDatabaseManager manager, IDatabaseConnection connection, PropertyInfoPath propertyPath)
		{
			var propertyInfo = propertyPath[propertyPath.Length-1];
			
			int length = 255;
			var attribute = propertyInfo.GetCustomAttribute<DatabaseLengthAttribute>();
			if (attribute != null)
			{
				length = attribute.Value;
				
				if (length == 1)
					return "Char";
			}
			
			return string.Format("VARCHAR({0})", length);
		}
	}
}