npoco

npoco is a node.js command tools to generate petapoco(micro-ORM) classes for .NET and Mono

Currently,npoco only support mysql database.

See here - https://github.com/toptensoftware/PetaPoco - for PetaPoco details.

Features

support

• Mysql

usage

1.install npoco

npm install -g npoco

1.init a config

npoco init

2.gen PetaPoco's code

npoco gen

exmaple:https://github.com/feiin/npocoexample

help

• npoco -help
• npoco init -h
• npoco gen -h

options

generate3TierArchitecture

Type:Boolean

generate 3-tier architecture code. Default:false.

In .Net/Mono Project

usage

1.add PetaPoco.cs

https://github.com/toptensoftware/PetaPoco/blob/master/PetaPoco/PetaPoco.cs

Download PetaPoco and copy master/PetaPoco/PetaPoco.cs to your project

2.copy generate Database.cs file to your project

3.web.config or app.config

 <connectionStrings>
    <add name="PetaPocoDb" connectionString="server=localhost;User Id=root;password=pass;database=db;" providerName="MySql.Data.MySqlClient" />
  </connectionStrings>
  
  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>

PetaPoco Usage :http://www.toptensoftware.com/petapoco/