Custom Membership..forms.
Don’t advocate roll own membership
ASP.NET Membership works if
- SQL Server forever
- Forms auth
- Can login multiple times
OpenID
TDD/BDD do this.
Code Snippets
To help with mundane writing code in unit tests.
Ctrl K Ctrl B
http://weblogs.asp.net/kdente/archive/2005/05/05/405843.aspx Kevin Dentes Blogs and nunit snippets **not imported yet as wasn’t in .snippet format
Libraries\Documents\Visual Studio 2010\Code Snippets\Visual C#\My Code Snippets
Git console in VS
Tools/External menu.
which then appears in the Tools menu as git. Change to &g for keyboard accelerator.
Feature branch in Git
Master is for finalised and deployed (?) code
git branch (to see current branches)
git checkout –b membership
.gitignore
*resharper.user
[Dd]ebug/
[Rr]elease/
build/
[Bb]in/
[Oo]bj/
*.suo
*.sln.cache
_ReSharper.*/
*.user
git add .
Global GitIgnore
http://jqr.github.com/2009/02/03/global-git-ignore.html
git config –global core.excludesfile c:/dev/Global.gitignore
Test 1 – Not Accept Email with < 6 Chars
From http://weblogs.asp.net/nunitaddin/
Alt + T reassigned for run tests in TestDriven.Net
Alt + D run tests in debug
Code Snippet
public class TestBase {
public void Describes(string description) {
Console.WriteLine("-------------------------------");
Console.WriteLine(description);
Console.WriteLine("-------------------------------");
}
public void isPending() {
Console.WriteLine(GetCaller() + " -- PENDING --");
Assert.Inconclusive();
}
public string GetCaller() {
StackTrace stack = new StackTrace();
return stack.GetFrame(2).GetMethod().Name.Replace("_", " ");
}
}
So can get a bit of nice debug in output window:
YAGNI – writing smallest amount of code to make test pass.. weird but good.
Code Snippet
[TestFixture]
public class MembershipSpecs : TestBase{
public MembershipSpecs() {
this.Describes("User Registration");
}
[Test]
public void registration_should_not_accept_email_with_lt_6_chars() {
var membership = new Membership();
var result = membership.Register("test@test.com", "password", "password");
Assert.False(result.Success);
}
}
and simplest possible implementation (not really, but Rob has an end in mind)
used Ctrl . in VS to make Membership class and file, and method.
Code Snippet
public class Membership {
public dynamic Register(string email, string password, string confirm) {
dynamic result = new ExpandoObject();
result.Success = false;
return result;
}
}
Code Snippet
[Test]
public void registration_should_not_accept_email_with_lt_6_chars() {
var result = _membership.Register("e", "password", "password");
Assert.False(result.Success);
}
[Test]
public void registration_should_not_accept_password_with_lt_6_chars() {
var result = _membership.Register("test@test.com", "x", "x");
Assert.False(result.Success);
}
[Test]
public void registration_should_not_accept_mismatched_passwords() {
var result = _membership.Register("test@test.com", "password1", "password2");
Assert.False(result.Success);
}
testing the False cases
Code Snippet
public dynamic Register(string email, string password, string confirm) {
dynamic result = new ExpandoObject();
result.Success = false;
if (email.Length >= 6 && password.Length >=6 && password.Equals(confirm))
result.Success = true;
return result;
}
Persist Information to DB – Massive
http://blog.wekeroad.com/helpy-stuff/and-i-shall-call-it-massive
Rails doesn’t matter to goto db..can be fast enough.
SQL CE4 in App_Data in Test project. **This didn’t work.. am using SQL Server**
Seed on ID the PK. getdate() on 3 date fields as default.
How to persist data? Simplest possible for now is Massive.. a Dynamic ORM in 500lines or do.
https://github.com/robconery/massive
Test 2 – Registration Should Not Accept Duplicate Emails
Test is something like:
[Test]
public void registration_should_not_accept_duplicate_emails() {
var result = _membership.Register("test@test.com", "password", "password");
var result2 = _membership.Register("test@test.com", "password", "password");
Assert.False(result2.Success);
}
so need persistence to test this:
Going to clean the db before each test!
Massive works by translating the properties of the anonymous object into column names:
Problem: Couldn’t get Massive to connect to SQLServerCompact4.0 database with connection string:
<?xml version="1.0" encoding="utf-8" ?>
<configuration> <connectionStrings> <add name="Membership" connectionString="Data Source=C:\Dev\VidPub\Source\VidPub.Tests\App_Data\Membership_Test.sdf" providerName="System.Data.SqlServerCE.4.0" /> </connectionStrings>
</configuration>
installed classic 2000 Northwind sample:
http://www.microsoft.com/download/en/confirmation.aspx?id=23654 then look in C:\SQL Server 2000 Sample Databases
http://ndc2011.macsimum.no/mp4/Day2%20Thursday/Track1%201140-1240.mp4 – Interesting talk from Norway on Data access history.
Now I can get a console App to talk to SQL Server Compact 4.0 :
string connectionString = ConfigurationManager.ConnectionStrings["southwind"].ConnectionString;
//SqlCeConnection connection = new SqlCeConnection(@"Data Source=SouthWind.sdf");
SqlCeConnection connection = new SqlCeConnection(connectionString);
SqlCeCommand command = new SqlCeCommand("SELECT * FROM People", connection);
SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
Console.WriteLine(ds.GetXml());
now I need to get Massive talking to that db.
I can kind of get it working by changing the _providerName to
var _providerName = "System.Data.SqlServerCE.4.0";
https://github.com/robconery/massive/pull/65 here is a fix by pulling from the App.config.
Getting strange errors!
Reverting to SQL Server
<configuration>
<connectionStrings>
<!--<add name="Membership" providerName="System.Data.SqlServerCE.4.0" connectionString="Data Source=C:\Dev\VidPub\Source\VidPub.Tests\Membership_Test.sdf" />-->
<add name="Membership" providerName="System.Data.SqlClient" connectionString="Data Source=.\;Initial Catalog=Membership_Test;Integrated Security=SSPI;" />
</connectionStrings>
</configuration>
and change provider name back to:
var _providerName = "System.Data.SqlClient";
and to put a unique constrant on SQL Server column: http://stackoverflow.com/questions/64981/sql-server-2005-how-create-a-unique-constraint
Code Snippets
testn is setup for me to produce:
[Test] public void MyTestMethod() { }