People search engine Pipl's

API can be used to bring a variety of information about an individual, from social networks like Facebook and LinkedIn to government resources like the United States Patent and Trademark Office and county clerk offices, into any application

development,search

My first FireFox plugin released

Here are few screen shots of this

Cast<DataRow>

the following code will load top 5 rows Order in ascending row filter rows based on current date 

   1: return rows.Count() > 0 ? dt.Rows.Cast<DataRow>()

   2: .OrderByDescending(r => r["StartDate"]).

   3: Where(j => (DateTime)j["StartDate"] >= DateTime.Now).

   4: Take(5).CopyToDataTable() ;

Discover who’s tracking you online

Collusion is an experimental add-on for Firefox and allows you to see all the third parties that are tracking your movements across the Web. It will show, in real time, how that data creates a spider-web of interaction between companies and other trackers

more info

linqpad

 

LINQPad is a free software utility for Microsoft .NET developers using LINQ. It allows developers to interactively query SQL databases and other data sources such WCF Data Services using LINQ.

LINQPad supports the following LINQ dialects:

• LINQ to Objects
• LINQ to SQL
• Entity Framework
• LINQ to XML

It also supports writing queries in SQL as well.

Aside from being useful for writing queries, LINQPad can be used to interactively write C# code without having to compile it. This expands its use to a general "test workbench" where C# code can be quickly prototyped outside of Visual Studio.

download linqpad

Find Text within all stored procedures

 

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%searchstring%'

The following statement will search all stored proc in database containing the name ‘aspnet_Membership

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%aspnet_Membership_%'

following statement will search a text inside the stored procedure

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%INNER JOIN aspnet_UsersInRoles UR%'

 

NPOI

 

This project is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. It has a wide application.

For example, you can use it to generate a Excel report without Microsoft Office suite installed on your server and more efficient than call Microsoft Excel ActiveX at background; you can also use it to extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines).

more info

NuGet

 

NuGet is a Visual Studio extension that makes it easy to install and update open source libraries and tools in Visual Studio.

When you use NuGet to install a package, it copies the library files to your solution and automatically updates your project (add references, change config files, etc). If you remove a package, NuGet reverses whatever changes it made so that no clutter is left.

more info

Explicitly Implementing Interface

 

Explicit implementation can be helpful when class implements interfaces having save method signatures

interface IAgency
    {
        void AddUpdate();
    }
    interface IPackage
    {
        void AddUpdate();
    }
    class Travel : IAgency, IPackage
    {
        public void AddUpdate()
        {
        }
    }

By Implementing Interfaces explicitly we can avoid the above problem

interface IAgency
{ 
    void AddUpdate();    
}
interface IPackage
{ 
  void AddUpdate();    
}
class Travel : IAgency,IPackage
    {
        
        void IAgency.AddUpdate()
        {
            throw new NotImplementedException();
        }
        void IPackage.AddUpdate()
        {
            throw new NotImplementedException();
        }
}

Travel obj = new Travel();
//obj.AddUpdate();  // Compiler error.
IAgency objAgency = (IAgency)obj;
objAgency.AddUpdate();  // Calls IAgency.AddUpdate on Travel 
IPackage objPackage = (IPackage)obj;
objPackage.AddUpdate(); // Calls IPackage.AddUpdate on Travel