Introduction

Dragon is a simplified ORM tool. It has similar syntax to Matrix.Data.Database, but maps to static types not dynamic. E.g.

Database database = Database.Open("Users");
var users = database.Query<TestUser>("select UserId, Email from UserProfile where UserId=@UserId",
				new { UserId = 2 }).ToList();
Assert.AreEqual(2, users[0].UserId);
Assert.AreEqual("user@company.com", users[0].Email);

Database Methods

The Database Class has methods Open, Execute QueryValue and Query.

• Open, opens database connection, the parameter can be a connection string, or a connection string name in app.config file or a registry path to a connection string.
• Execute, creates a command and runs ExecuteNonQuery.
• QueryValue, creates a command and runs ExecuteScalar.
• Query, creates a command with SQL statement(s) or stored procedure name and creates objects. The Query method supports up to 3 multiple record sets. The result objects are returned in a Tuple, E.g.

Database database = Database.Open("Users");
var users = database.Query<TestUser, TestMemberShip, TestUserRole>(
	@"select * from dbo.UserProfile
		select * from dbo.webpages_Membership
		select * from dbo.webpages_Roles");

Assert.AreEqual(1, users.Item1.ToList()[0].UserId);
Assert.AreEqual(0, users.Item2.Count());
Assert.AreEqual("Sysadmin", users.Item3.ToList()[0].RoleName);

Source Code

https://github.com/yysun/Dragon