ASP.NET Profile

• ASP.NET Quickstart Tutorials – Storing User Profiles
• MSDN – SqlProfileProvider Class
• MSDN – ASP.NET Profile Properties
  • MSDN – ASP.NET Profile Properties Overview
  • MSDN – ASP.NET User Identification for ASP.NET Profile Properties
  • MSDN – Defining ASP.NET Profile Properties
  • MSDN – ASP.NET Profile Provider
  • MSDN – Implementing a Profile Provider
    • MSDN – How to: Build and Run the Profile Provider Example
      • MSDN – Profile Provider Implementation Example
  • MSDN – Securing Profile Properties
• Table Profile Provider and Stored Procedure Profile Provider - the easiest to understand and adopt; works extremely well
• TechTarget.com – Creating custom ASP.NET 2.0 profile providers – very interesting way of implementing it\
• OdeToCode.com – Profiles in ASP.NET 2.0 – A pretty thorough examination of the default SqlProfileProvider
• EggHeadCafe.com – Integrating Customized Roles, Membership and Profiles in ASP.NET 2.0

ASP.NET Roles

• MSDN – Roles Class – first place to consult if anything!
• MSDN – Role Provider
• MSDN – How To: Use Role Manager in ASP.NET 2.0
• MSDN – roleManager Element (ASP.NET Settings Schema)
• ASP.NET Quickstart Tutorials – Using the Membership and Role Manager APIs

The .NET Framework type to ADO.NET data type mappings

.NET Framework Type	ADO.NET Database Type	SQL Data Type
String	Varchar	Varchar()
String	Nvarchar	Nvarchar()
String	NChar	Nchar()
String	NText	NText
String	Text	Text
Double	BigInt	Float
DateTime	DateTime	Datetime
DateTime	SmallDateTime	Smalldatetime
Int	Int	Int
Int64	BigInt	Bigint
Int16	SmallInt	smallint
Byte[]	Binary	Binary()
Byte[]	Image	Image
Byte[]	VarBinary	Varbinary()
Byte	TinyInt	Tinyint
Bool	Bit	Bit
Decimal	Decimal	Decimal
Decimal	Money	Money
Decimal	SmallMoney	SmallMoney
Float	Float	Float
Guid	UniqueIdentifier	Uniqueidentifier
Real	Real	Real