ldap authentication..store user data in local SLQ table

[crazyitguy]

This question is not specific to .net; just some theory...

Lets say I wanted to authenticate users against an LDAP directory such as Acitvie Directory. The directory also has other attributes for each user such as fname, lname, etc, etc. Would it be "better" to grab that data and store it in our application's local SQL database or retrieve from LDAP every time we need it.

thanks

 

[Guru7777]

I actually had to do a similar thing once upon a time, however, I didn't store the data locally in a database. What I did was create a business object that had the properties laid out in your LDAP compatible directory. On first load, populate the business object and as long as the object can remain in scope, you have the data. It is a lot less expensive than calling out to AD or SQL Server.

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==