DbEntry.Net (Lephone Framework)

Source code checked in, #34220

lifeng — Fri, 04 Jul 2008 10:11:15 GMT

work item: 17254

Source code checked in, #34199

lifeng — Thu, 03 Jul 2008 09:21:53 GMT

work item: 17240

Updated Wiki: Multiple data source

lifeng — Mon, 30 Jun 2008 08:09:16 GMT

Multiple data source

In DbEntry, DbContext is the main interface to access database. And there is default context in DbEntry class called Context. DbEntry just provides some static functions to call the same name functions in Context. And if the object models inherit from DbObjectModel, the functions extra by it is operate DbEntry.Context too. So, it’s very easy to use the default context.

If there is DefaultContext node in App.config/Web.config, it will use this argument to get the default context, otherwise it using the empty string as the argument to get it.

<Lephone.Settings>
    <add key="DataBase" value="@Access : @~test.mdb" />
</Lephone.Settings>

And the following is the same meaning as above:

<Lephone.Settings>
    <add key="DefaultContext" value="Access" />
    <add key="Access.DataBase" value="@Access : @~test.mdb" />
</Lephone.Settings>

More details about config file please read Configuration.

And we can use the other context to operate other database.

<Lephone.Settings>
    <add key="DataBase" value="@Access : @~test.mdb" />
    <add key="Excel.DataBase" value="@Excel : @~test.xls" />
</Lephone.Settings>

And all of the key names of one database setting should have the same prefix:

<Lephone.Settings>
    <add key="DefaultContext" value="MySql" />
 
    <add key="MySql.DataBase" value="@MySql : server=localhost;user id=root; password=123; database=mytest; pooling=false" />
    <add key="MySql.DbProviderFactory" value="@SmartDbFactory : MySql.Data, Version=5.1.2.2, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
 
    <add key="sqlite.DataBase" value="@SQLite : @~Test.db" />
    <add key="sqlite.DbProviderFactory" value="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.36.1, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
</Lephone.Settings>

The code to use excel context:

DbContext ds = new DbContext("Excel");
IList list = ds.From<BookInfo>().Where(null).Select();

Ensure the DbContext only has one instance to the single context setting is the good choice. If there are many instance of DbContext to operate the database in the same time, it may confuse the auto create table feature. Of course, if you don’t use this feature, it doesn’t matter.

Please remember that if we using transaction by context, the operations in the scope must be the same context. If use the secondary context, make sure the code in the transaction scope are NOT using the default context.

DbContext ds = new DbContext("MySql");
ds.UsingTransaction(delegate()
{
    User.New(“tom”).Save() // wrong, it should use ds to save
});

Updated Wiki: Home

lifeng — Sat, 28 Jun 2008 02:16:04 GMT

DbEntry.Net (Lephone Framework)

DbEntry.Net (Lephone Framework) is a lightweight, high performance ORM compnent for .Net 2.0 and 3.5. It has clearly and easily programing interface. It based on ADO.NET, and supported C#, Visual Basic, ASP.NET etc. It also provide DbEntryDataSource for ASP.NET 2.0 and a Rails style MVC framework for web develpment.

The samples of the release package all TESTED on Sql Server 2005 Express, MySql 5.0, SQLite 3, Access 2003, Firebird 2.0.3 and Oracle 10g express.

Features:

FluentInterface query syntax
RoR ActiveRecord style syntax
Ambient transaction
Dynamic object
Partial update
1:1 1:Many Many:Many relations
Auto create table
Anti sql injection
Multiple data source
Object validation
Paged selector and collection
Nullable support
DbEntryDataSource
ASP.NET 2.0 Membership support
Built-in Cache Support
Ruby On Rails style MVC framework
High performance, almost same as using ADO.NET directly
Lightwight, the binary file only about 268KB

Tutorials

Data Access

Getting started

Definition and Configuration:

Details:

ASP.NET

Rails Style MVC

Working In Progress

Utils

Appendix

Source code checked in, #34149

lifeng — Fri, 27 Jun 2008 09:57:21 GMT

work item: 17061

Updated Wiki: Simple IoC

lifeng — Mon, 23 Jun 2008 14:51:20 GMT

Simple IoC

Attention: this article belongs to working in progress. It means it isn’t in the current release and not stable yet, but you can get the latest check-in in source code repository to taste of it.

DbEntry.Net provide a simple IoC framework for dependence creation and dependence injection.

The main goal of it is simple but useful. I don't want it to replace other high level IoC framework. Just wish it could handle 70% common scenarios.

It is in Lephone.Util.IoC.

Define objects:

[DependenceEntry]
public interface ITest
{
    string Run();
}
 
[Implementation]
public class TestImpl : ITest
{
    public string Run()
    {
        return "1st impl";
    }
}
 
[Implementation("2nd")]
public class NewTestImpl : ITest
{
    public string Run()
    {
        return "2nd impl";
    }
}

Use:

var t = SimpleContainer.Get<ITest>();
Assert.IsNotNull(t);
Assert.IsTrue(t is TestImpl);
 
var t2 = SimpleContainer.Get<ITest>("2nd");
Assert.IsNotNull(t2);
Assert.IsTrue(t2 is NewTestImpl);

It also works for base class mode and property injection:

[DependenceEntry, Implementation]
public class IocSame
{
    public virtual string Run()
    {
        return "same";
    }
 
    [Injection("2nd")]
    public ITest TestProperty { get; set; }
}
 
[Implementation("sub")]
public class IocSameSub : IocSame
{
    public override string Run()
    {
        return "sub class";
    }
}
 
public class IocSameReg : IocSame
{
    public override string Run()
    {
        return "reg class";
    }
}

Use:

var t3 = SimpleContainer.Get<IocSame>();
Assert.IsNotNull(t3);
Assert.AreEqual("same", t3.Run());
 
var t4 = SimpleContainer.Get<IocSame>("sub");
Assert.IsNotNull(t4);
Assert.IsTrue(t4 is IocSameSub);
Assert.AreEqual("sub class", t4.Run());
 
SimpleContainer.Register<IocSame, IocSameReg>("reg");
var t = SimpleContainer.Get<IocSame>("reg");
Assert.IsNotNull(t);
Assert.AreEqual("reg class", t.Run());
Assert.IsNotNull(t.TestProperty);
Assert.AreEqual("2nd impl", t.TestProperty.Run());

And it works for constrctor injection too:

[DependenceEntry, Implementation]
public class IocConstractor
{
    private readonly ITest test;
 
    public IocConstractor([Injection("2nd")]ITest test)
    {
        this.test = test;
    }
 
    public virtual string Run()
    {
        return test.Run();
    }
}

Use:

var item = SimpleContainer.Get<IocConstractor>();
Assert.IsNotNull(item);
Assert.AreEqual("2nd impl", item.Run());

Configration

There is a configration item to enable or disable IoC, the default value is true:

<add key="IOC.EnableAutoLoad" value="false" />

And the assemblies which we defined the IoC objects should added to the assembly list:

<add key="IOC.SearchAssembly.1" value="Lephone.UnitTest" />
<add key="IOC.SearchAssembly.2" value="Lephone.Util" />

It will search for the key start at 1 until can not find the next key.

Source code checked in, #34087

lifeng — Mon, 23 Jun 2008 14:42:09 GMT

Rename folder Ioc as IoC

Source code checked in, #34086

lifeng — Mon, 23 Jun 2008 14:39:27 GMT

Don't download this change set.

Updated Wiki: Simple IoC

lifeng — Mon, 23 Jun 2008 14:31:46 GMT

Simple IoC

[DependenceEntry]
public interface ITest
{
    string Run();
}
 
[Implementation]
public class TestImpl : ITest
{
    public string Run()
    {
        return "1st impl";
    }
}
 
[Implementation("2nd")]
public class NewTestImpl : ITest
{
    public string Run()
    {
        return "2nd impl";
    }
}

Use:

var t = SimpleContainer.Get<ITest>();
Assert.IsNotNull(t);
Assert.IsTrue(t is TestImpl);
 
var t2 = SimpleContainer.Get<ITest>("2nd");
Assert.IsNotNull(t2);
Assert.IsTrue(t2 is NewTestImpl);

It also works for base class mode and property injection:

[DependenceEntry, Implementation]
public class IocSame
{
    public virtual string Run()
    {
        return "same";
    }
 
    [Injection("2nd")]
    public ITest TestProperty { get; set; }
}
 
[Implementation("sub")]
public class IocSameSub : IocSame
{
    public override string Run()
    {
        return "sub class";
    }
}
 
public class IocSameReg : IocSame
{
    public override string Run()
    {
        return "reg class";
    }
}

Use:

var t3 = SimpleContainer.Get<IocSame>();
Assert.IsNotNull(t3);
Assert.AreEqual("same", t3.Run());
 
var t4 = SimpleContainer.Get<IocSame>("sub");
Assert.IsNotNull(t4);
Assert.IsTrue(t4 is IocSameSub);
Assert.AreEqual("sub class", t4.Run());
 
SimpleContainer.Register<IocSame, IocSameReg>("reg");
var t = SimpleContainer.Get<IocSame>("reg");
Assert.IsNotNull(t);
Assert.AreEqual("reg class", t.Run());
Assert.IsNotNull(t.TestProperty);
Assert.AreEqual("2nd impl", t.TestProperty.Run());

And it works for constrctor injection too:

[DependenceEntry, Implementation]
public class IocConstractor
{
    private readonly ITest test;
 
    public IocConstractor([Injection("2nd")]ITest test)
    {
        this.test = test;
    }
 
    public virtual string Run()
    {
        return test.Run();
    }
}

Use:

var item = SimpleContainer.Get<IocConstractor>();
Assert.IsNotNull(item);
Assert.AreEqual("2nd impl", item.Run());

Updated Wiki: Simple IoC

lifeng — Mon, 23 Jun 2008 14:30:05 GMT

Simple IoC

DbEntry.Net provide a simple IoC framework for dependence creation and dependence injection.

The main goal of it is simple but useful. I don't want it to replace other high level IoC framework. Just wish it could handle 70% scenario.

It is in Lephone.Util.IoC.

Define objects:

[DependenceEntry]
public interface ITest
{
    string Run();
}
 
[Implementation]
public class TestImpl : ITest
{
    public string Run()
    {
        return "1st impl";
    }
}
 
[Implementation("2nd")]
public class NewTestImpl : ITest
{
    public string Run()
    {
        return "2nd impl";
    }
}

Use:

var t = SimpleContainer.Get<ITest>();
Assert.IsNotNull(t);
Assert.IsTrue(t is TestImpl);
 
var t2 = SimpleContainer.Get<ITest>("2nd");
Assert.IsNotNull(t2);
Assert.IsTrue(t2 is NewTestImpl);

It also works for base class mode and property injection:

[DependenceEntry, Implementation]
public class IocSame
{
    public virtual string Run()
    {
        return "same";
    }
 
    [Injection("2nd")]
    public ITest TestProperty { get; set; }
}
 
[Implementation("sub")]
public class IocSameSub : IocSame
{
    public override string Run()
    {
        return "sub class";
    }
}
 
public class IocSameReg : IocSame
{
    public override string Run()
    {
        return "reg class";
    }
}

Use:

var t3 = SimpleContainer.Get<IocSame>();
Assert.IsNotNull(t3);
Assert.AreEqual("same", t3.Run());
 
var t4 = SimpleContainer.Get<IocSame>("sub");
Assert.IsNotNull(t4);
Assert.IsTrue(t4 is IocSameSub);
Assert.AreEqual("sub class", t4.Run());
 
SimpleContainer.Register<IocSame, IocSameReg>("reg");
var t = SimpleContainer.Get<IocSame>("reg");
Assert.IsNotNull(t);
Assert.AreEqual("reg class", t.Run());
Assert.IsNotNull(t.TestProperty);
Assert.AreEqual("2nd impl", t.TestProperty.Run());

And it works for constrctor injection too:

[DependenceEntry, Implementation]
public class IocConstractor
{
    private readonly ITest test;
 
    public IocConstractor([Injection("2nd")]ITest test)
    {
        this.test = test;
    }
 
    public virtual string Run()
    {
        return test.Run();
    }
}

Use:

var item = SimpleContainer.Get<IocConstractor>();
Assert.IsNotNull(item);
Assert.AreEqual("2nd impl", item.Run());

Updated Wiki: Home

lifeng — Mon, 23 Jun 2008 14:15:18 GMT

DbEntry.Net

DbEntry.Net is a lightweight, high performance ORM compnent for .Net 2.0 and 3.5. It has clearly and easily programing interface. It based on ADO.NET, and supported C#, Visual Basic, ASP.NET etc. It also provide DbEntryDataSource for ASP.NET 2.0 and a Rails style MVC framework for web develpment.

The samples of the release package all TESTED on Sql Server 2005 Express, MySql 5.0, SQLite 3, Access 2003, Firebird 2.0.3 and Oracle 10g express.

Features:

FluentInterface query syntax
RoR ActiveRecord style syntax
Ambient transaction
Dynamic object
Partial update
1:1 1:Many Many:Many relations
Auto create table
Anti sql injection
Multiple data source
Object validation
Paged selector and collection
Nullable support
DbEntryDataSource
ASP.NET 2.0 Membership support
Built-in Cache Support
Ruby On Rails style MVC framework
High performance, almost same as using ADO.NET directly
Lightwight, the binary file only about 268KB

Tutorials

Data Access

Getting started

Definition and Configuration:

Details:

ASP.NET

Rails Style MVC

Working In Progress

Utils

Appendix

Source code checked in, #34078

lifeng — Sun, 22 Jun 2008 13:34:34 GMT

work items: 17112, 17113

Source code checked in, #34062

lifeng — Fri, 20 Jun 2008 09:54:07 GMT

work items: 17066, 17110

Commented Feature: Add XDictinonary to Lephone.Util

lifeng — Wed, 18 Jun 2008 13:27:12 GMT

Add XDictinonary to Lephone.Util.
It will make the Dictionary works for xml sererliztion.
Comments: Fixed on changeset 34047

Commented Task: Remove TransactionRequestFilter from Lephone.Web

lifeng — Wed, 18 Jun 2008 13:27:00 GMT

Remove TransactionRequestFilter from Lephone.Web.
It doesn't work for page bacause the HttpModule runs in another thread.
PostSharp is a better way to handle such issueses.
http://www.postsharp.org/
Comments: Fixed on changeset 34047

Source code checked in, #34047

lifeng — Wed, 18 Jun 2008 13:26:47 GMT

work items: 17055, 17089

Created Feature: Add XDictinonary to Lephone.Util

lifeng — Wed, 18 Jun 2008 02:46:23 GMT

Add XDictinonary to Lephone.Util.
It will make the Dictionary works for xml sererliztion.

Created Feature: Add Lephone.Web.jQuery.Binding

lifeng — Mon, 16 Jun 2008 15:24:26 GMT

Add Lephone.Web.jQuery.Binding for some common functionabilities such like client validating...
It maybe a long time plan.

Created Feature: Add CheckableGridView to Lephone.Web

lifeng — Mon, 16 Jun 2008 15:22:05 GMT

Add CheckableGridView to Lephone.Web if possiable.....

It is a web control inherits from GridView and have a column with checkbox and in the header with a "select all/unselect all" checkbox.

Created Feature: Add simple IoC to Lephone.Util

lifeng — Mon, 16 Jun 2008 15:12:07 GMT

Add simple IoC to Lephone.Util.
In fact, ClassHelper.CreateInstance and ConfigHelper is simple Ioc functions. But it only works for full type name and base class mode.
Add some custom attributes for interface and sub classes so it can works for them.
Keep it useful and simple.

DbEntry.Net (Lephone Framework)

Source code checked in, #34220

Source code checked in, #34199

Updated Wiki: Multiple data source

Multiple data source

Updated Wiki: Home

DbEntry.Net (Lephone Framework)

Tutorials

Links

Source code checked in, #34149

Updated Wiki: Simple IoC

Simple IoC

Configration

Source code checked in, #34087

Source code checked in, #34086

Updated Wiki: Simple IoC

Simple IoC

Updated Wiki: Simple IoC

Simple IoC

Updated Wiki: Home

DbEntry.Net

Tutorials

Links

Source code checked in, #34078

Source code checked in, #34062

Commented Feature: Add XDictinonary to Lephone.Util

Commented Task: Remove TransactionRequestFilter from Lephone.Web

Source code checked in, #34047

Created Feature: Add XDictinonary to Lephone.Util

Created Feature: Add Lephone.Web.jQuery.Binding

Created Feature: Add CheckableGridView to Lephone.Web

Created Feature: Add simple IoC to Lephone.Util