Hi I am developing a social networking website and I want to use Membership provider how can I do that.

Either you use the out of the box ASP.NET SQL membership provider provided by MS, which then will install some SPs to manage database interactions. (LLBLGen has nothing to do with it)

Or implement your own LLBLGen Pro membership provider, if you want to use LLBLGen Pro under the hood.