using System.Web.Mvc; using DIControllerFactoryExample.Tools; namespace DIControllerFactoryExample.Controllers
{ publicclass HomeController
: Controller { privatereadonly IPersonRepository
personRepository; public HomeController(IPersonRepository
personRepository) { this.personRepository = personRepository;
} public ActionResult
Index() { var personid = 1;
ViewData.Model = personRepository.Get(personid); return View();
} } }

using StructureMap.Configuration.DSL; namespace DIControllerFactoryExample.Tools
{ publicclass DefaultStructureMapRegistry
: Registry { public DefaultStructureMapRegistry()
{ ForRequestedType<IPersonRepository>().TheDefaultIsConcreteType <PersonRepository>();
} } }
using System; using System.Collections.Generic; using Microsoft.Practices.ServiceLocation; using StructureMap; namespace DIControllerFactoryExample.Tools
{ publicclass StructureMapServiceLocator
: ServiceLocatorImplBase { private IContainer
container; public StructureMapServiceLocator(IContainer
container) { this.container = container;
} protectedoverrideobject DoGetInstance(Type
serviceType, string key)
{ returnstring.IsNullOrEmpty(key)
? container.GetInstance(serviceType) : container.GetInstance(serviceType, key); } protectedoverride IEnumerable<object>
DoGetAllInstances(Type serviceType) { foreach (object obj in container.GetAllInstances(serviceType))
{ yield return obj;
} } } } 

using System; using System.Web.Mvc; using Microsoft.Practices.ServiceLocation; namespace DIControllerFactoryExample.Tools
{ publicclass StructureMapServiceLocatorControllerFactory
: DefaultControllerFactory { protectedoverride IController
GetControllerInstance(Type controllerType) { var controller = ServiceLocator.Current.GetInstance(controllerType) as Controller; return controller;
} } } 

var
registry =new DefaultStructureMapRegistry();
var container =new Container(registry);
ServiceLocator.SetLocatorProvider(() => new StructureMapServiceLocator(container));
var locator =new StructureMapServiceLocatorControllerFactory();
ControllerBuilder.Current.SetControllerFactory(locator);

C:\Users\gm>qwinsta
/server:kraftwerk SESSIONNAME USERNAME ID STATE TYPE DEVICE services 0 Disc console
1 Conn rdp-tcp#0 gm 2 Active rdpwd rdp-tcp 65536 Listen

C:\Users\gm>rwinsta
/server:kraftwerk rdp-tcp#0

SELECTTOP 10 substring(O.Functions,2,500) FROM dbo.Tp_Person
P CROSS APPLY
( SELECT',' + CAST(FunctionName ASvarchar) AS [text()] FROM dbo.Tp_Function
F WHERE F.Personid
= P.Personid FOR XML
PATH('')
) O( Functions )



This trick actually reduced the time of the procedure on 5000 people from about 30
seconds to 1,5 seconds. Made my day. 

Checking if a email addresses is valid in SQL can be very convinient from time to time. Here are two ways to do it in SQL, and a bit about them.

Here is a full SQL way to do this:

          
            Create
            function VALIDEMAIL(@s varchar(255)) 

--Returns
true if the string is a valid email address.

returns bit
as
BEGIN
DECLARE @u VARCHAR(60),
@v VARCHAR(60),
@x VARCHAR(60),
@i int,
@j int,
@result bit
SET @result=1
set @s
= rtrim(ltrim(@s))
SET @i=len(@s)-CHARINDEX('@',reverse(@s))+1
if @i
<= 1 orlen(@s)
< 5
begin

  set @result
= 0

  goto done
end
SET @u=LEFT(@s,@i-1)
SET @j=len(@s)-CHARINDEX('.',reverse(@s))+1
SET @v=RIGHT(@s,LEN(@s)-@j)
if @j
< 3 or @j
< @i
begin

  set @result
= 0

  goto done
end
SET @x=substring(@s,@i+1,@j-@i-1)
IFLEN(@x)<2

 BEGIN

 SET @result=0

 GOTo done

 END
IF (LEN(@x)=3) AND (@x NOTLIKE'[a-zA-Z][a-zA-Z][a-zA-Z]'Collate 
Latin1_General_BIN)

 BEGIN

 SET @result=0

 GOTo done

 END
IF (LEN(@x)=2) AND (@x NOTLIKE'[a-zA-Z][a-zA-Z]'Collate 
Latin1_General_BIN)

 BEGIN

 SET @result=0

 GOTo done

 END
SET @i=1
WHILE (@i<LEN(@u))

 BEGIN

 IFSUBSTRING(@u,@i,1) NOTLIKE'[a-zA-Z0-9_\-.+=/!#$&''*%?^`{|}"@\\
]'escape'\'Collate 
Latin1_General_BIN

  BEGIN

  SET @result=0

  GOTo done

  END

 SET @i=@i+1

 END
SET @i=1
WHILE (@i<LEN(@v))

 BEGIN

 IFSUBSTRING(@v,@i,1) NOTLIKE'[a-zA-Z]'Collate Latin1_General_BIN

  BEGIN

  SET @result=0

  GOTo done

  END

 SET @i=@i+1

 END
SET @i=1
WHILE (@i<LEN(@x))

 BEGIN

 IFSUBSTRING(@x,@i,1) NOTLIKE N'[a-zA-Z\-.0-9]'escape'\'Collate 
Latin1_General_BIN

  BEGIN

  SET @result=0

     goto done

  END

 SET @i=@i+1

 END

done:
return @result
END

GO

        

Here is another way, where you insert .NET CLR code in the database. Here I use the .NET RegEx.Ismatch, so I can use it for tons of other stuff as well with the right input.

          
            using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Server; using System.Data.SqlTypes; using System.Text.RegularExpressions; namespace SQLSignature
{ publicclass SqlFunctions
{ [SqlFunction(IsDeterministic =true,
DataAccess = DataAccessKind.None)] publicstatic SqlBoolean
fn_RegexIsMatch(SqlString input, SqlString pattern) { return (SqlBoolean)Regex.IsMatch(input.Value,
pattern.Value); } } } 
        

CREATE ASSEMBLY
SQLSignature FROM'C:\CLR
Assemblies\Performance\SQLFunctions\bin\SQLFunctions.dll'; GO --
Create fn_SQLSigCLR and fn_RegexReplace functionsCREATEFUNCTION dbo.fn_RegexIsMatch(@input ASNVARCHAR(MAX),@pattern ASNVARCHAR(MAX))RETURNS BITWITH RETURNS NULLONNULL INPUT
EXTERNAL NAME SQLSignature.SQLFunctions.fn_RegexIsMatch; GO 

    select *
    from [AW].[person].emailaddress as p
    where dbo.fn_RegexIsMatch(RTRIM(LTRIM(lower(P.emailaddress))),
 '^[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$')=1 

I did some timings on the two functions and as you can see below there are big differences. The .NET CLR one is almost 8 times faster(cpu time) than the T-SQL one. It's also a whole lot easier to read, and can be used for all other RegEx's needed. You do however need to get out of management studio to make it, and 1.5 seconds is for processing almost 20000 email addresses still should be fast enough for most uses.

SETSTATISTICS TIME ON     select *
    from [AW].[person].emailaddress as p
    where dbo.VALIDEMAIL(P.emailaddress)=1
    select *
    from [AW].[person].emailaddress as p
    where dbo.fn_RegexIsMatch(RTRIM(LTRIM(lower(P.emailaddress))),
'^[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$')=1
(19929 row(s) affected) SQL Server Execution Times: CPU time = 1466 ms, elapsed time
= 1911 ms. (19972 row(s) affected) SQL Server Execution Times: CPU time = 203 ms,
elapsed time = 380 ms. 

All most every ASP.NET website I have seen, uses Databinder.Eval(Container.DataItem, "colum1") in repeaters to get the data passed in and show it on screen. The problem with Databinder.Eval is that it uses reflection to evaluate the item. This is time consuming and unnecessary, so instead, one should use casting to obtain the same effect. Try not to do it this way:

          <asp:repeater
id="rptAccounts" runat="server">
    <itemtemplate>         <%#
Databinder.Eval(Container.DataItem, "colum1")
%> <br />     </itemtemplate> </asp:repeater> 
        

But use this one instead:

          <asp:repeater
id="rptAccounts" runat="server">

    <itemtemplate>

        <%# ((BusinessObjects.Object)Container.DataItem).Column1
%> <br />

    </itemtemplate>

</asp:repeater>


          

This will also give you a compiler warning if the members of a class should change,
and

not just runtime fail such as the first example. If you are not using business

objects, but a DataTable, you can  cast

to datarow and get the column right out of there like this:

          

            
              

            
          
          

            <asp:repeater
id="rptAccounts" runat="server">
    <itemtemplate>         <%#
((DataRow)Container.DataItem)["Column1"]
%> <br />     </itemtemplate> </asp:repeater> 
          
          

This both increases speed and makes the application more robust to runtime errors.
A win-win situation:) 

          

          

        

Third party applications are great, and its very often smart to use open source or buy modules you need before making your own. However a lot of third party applications do create some problems. One is that prices and functionality can change and new, better and cheaper products come to surface.

Therefore, you do not want to be to dependent on these applications, so if you find another tool that does the same thing even better, you should be able to switch it out easy. A good way to do this is to create a interface and a factory pattern, and refer to the interface in your code and let the factory class decide what tool to use.  You can also use this pattern to ease mocking of objects. And let the factory return a mock object if you are unit testing.

Example in C#:

          
            using System; namespace Logger
{ //
An interface is createdinterface iLog
{ bool Log(string s);
} //An
implementation using enterprise libraries loggingclass EntLog
: iLog { publicbool Log(string s)
{ //Implement
logic to save to logreturnfalse;
} } //An
implementation using log4net to save logs.class log4net
: iLog { publicbool Log(string s)
{ //Implement
logic to save to logreturnfalse;
} } //
A factory classclass LogFactory
{ //
Creates an object, of the right type.publicstatic iLog
CreateLog(){ returnnew log4net();
} } class Program
{ staticvoid Main(string[]
args) { //
Get the log object to use. iLog logger = LogFactory.CreateLog(); //Print
the type of logger used Console.Out.WriteLine(logger.GetType()); //
Log a message and write the result Console.Out.WriteLine(logger.Log("Something
is happening")); Console.ReadKey(); } } } 
        

To change this to use entLog instead of log4net, all you have to do is change the object created in the logfactory.  To add a new logger, all you have to do is create a new class to implement Ilog and change the creator to return the new logger. The creator could also have a constructor that takes an input, so that you can decide in the class using the log what kind of log you want to use.