Microsoft

Visual Studio, Wizards, Project Templates and Unsigned DLLS

If, after you followed all the steps at http://msdn.microsoft.com/en-us/library/ms185301(VS.80).aspx you are getting an error about unsigned DLLs…try adding the DLL to the bin folder of your project…

Just re-code the wizard in C#…I guess there is a reason all the examples are in C#…

MembershipUser to DataTable

Anyone know if there is a cleaner way to do this?

 

   1:  Private Function MembershipUser_To_DataTable(ByVal vMembershipUser As MembershipUser) As DataTable
   2:          Dim mDataTable As New DataTable
   3:          mDataTable.Columns.Add("Email")
   4:          mDataTable.Columns.Add("PasswordQuestion")
   5:          mDataTable.Columns.Add("Comment")
   6:          mDataTable.Columns.Add("IsApproved")
   7:          mDataTable.Columns.Add("CreateDate")
   8:          mDataTable.Columns.Add("LastLoginDate")
   9:          mDataTable.Columns.Add("LastActivityDate")
  10:          mDataTable.Columns.Add("LastPasswordChangedDate")
  11:          mDataTable.Columns.Add("UserId")
  12:          mDataTable.Columns.Add("IsLockedOut")
  13:          mDataTable.Columns.Add("LastLockoutDate")
  14:          mDataTable.Rows.Add(vMembershipUser)
  15:          Return mDataTable
  16:      End Function

SubSonic and .NET Role Providers?

As I was wiring up a project to use SubSonic I ran into a problem with my tables using reserved words.

SubSonic Reserved Words Error:

   1:  . colvarApplicationId.DefaultSetting = @"(newid())";

If you get the “Character is not valid” error as in the line above..there is a reserved word somewhere in your table

My database only contained the tables required for the .NET Role Provider and one user defined table. After telling SubSonic to only build classes for my table my project compiled at run time using the .abp without issue. I have not done enough testing to verify if there is an incompatibility here or just something funky in my code. I’m currently leaning towards incompatibility because I would never mess-up..er..um..I mean being that its a brand new project