<div dir="ltr">S2Dao.NET$B$r;H$$;O$a$?$P$+$j$N=i?4<T$G$9!#(B ML$B$NEj9F$b=i$a$F$$$?$7$^$9!#(B SQLite$B$N(BDB$B%"%/%;%9$KBP$7$F(BS2Dao.NET$B$rMxMQ$7$F$_$h$&$H;W$$!"(BConsole$B%"%W%j$N%5%s%W%k$r:n@.$7$F$_$^$7$?!#(B $B$7$+$7!":n@.$7$?(BDao$B%$%s%?%U%'!<%9$N%a%=%C%I8F$S=P$7$GNc30H/@8$7!"860x$,J,$+$i$:$K:$$C$F$$$^$9!#(B $BD9$/$J$j$^$9$,!"4D6-$J$I$r>\:Y$K=q$-$^$9$H0J2<$N$h$&$K$J$C$F$$$^$9!#(B $B4D6-(B---------------------------------- OS$B!'(BWindows XP SP3 $B8@8l!'(BC#(.NET Framework3.5) $B3+H/4D6-!'(BVisualStudio 2008 DB$B!'(BSQLite(SQLite.dll <a href="http://1.0.59.0" target="_blank">1.0.59.0</a>) S2Dao.NET$B!'(B1.3.11 -------------------------------------- $B9=@.(B---------------------------------- $B!Z%=%j%e!<%7%g%s![(B MyS2DaoSample    $B(1(,!Z%W%m%8%'%/%H![(BMyS2DaoSample    $B!!!!!!(2(,!Z;2>H![(BSeasar.dll$B!"(BSeasar.Dao.dll$B!"(BSQLite.dll    $B!!!!!!(2(,!Z@_Dj%U%!%$%k![(Bapp.config$B!"(Bapp.dicon,Dao.dicon,S2Dao.dicon,Ado.dicon($B$=$l$>$l!"!V>o$K%3%T!<$9$k!W$K@_Dj(B)    $B!!!!!!(2(,!Z%/%i%9![(BILibraryDao.cs, Library.cs, Program.cs    $B!!!!!!(1(,!Z(BDB$B%U%!%$%k![(BLibrary.SQ3   -------------------------------------- app.config---------------------------- <configuration>   <configSections>     <section name="seasar" type="Seasar.Framework.Xml.S2SectionHandler, Seasar" />   </configSections>   <seasar>     <configPath>App.dicon</configPath>     <assemblys>       <assembly>Seasar.Dao</assembly>       <assembly>System.Data.SQLite</assembly>     </assemblys>   </seasar> </configuration> -------------------------------------- App.dicon----------------------------- <components>   <include path="Dao.dicon"/> </components> -------------------------------------- Dao.dicon----------------------------- <components namespace="Dao">   <include path="S2Dao.dicon"/>   <component class="MyS2DaoSample.ILibraryDao">     <aspect>S2Dao.Interceptor</aspect>   </component> </components> -------------------------------------- S2Dao.dicon--------------------------- <components namespace="S2Dao">   <include path="Ado.dicon" />   <component class="Seasar.Extension.ADO.Impl.BasicDataReaderFactory" />   <component class="Seasar.Extension.ADO.Impl.BasicCommandFactory" />   <component class="Seasar.Dao.Impl.FieldAnnotationReaderFactory" />   <component class="Seasar.Dao.Impl.DaoMetaDataFactoryImpl" />   <component name  ="Interceptor"     class ="Seasar.Dao.Interceptors.S2DaoInterceptor"/> </components> -------------------------------------- Ado.dicon----------------------------- <components namespace="Ado">   <component name="SQLiteClient" class="Seasar.Extension.ADO.DataProvider">     <property name="ConnectionType">"System.Data.SQLite.SQLiteConnection"</property>     <property name="CommandType">"System.Data.SQLite.SQLiteCommand"</property>     <property name="ParameterType">"System.Data.SQLite.SQLiteParameter"</property>     <property name="DataAdapterType">"System.Data.SQLite.SQLiteDataAdapter"</property>   </component>     <component name="DataSource" class="Seasar.Extension.Tx.Impl.TxDataSource">     <property name="DataProvider">SQLiteClient</property>     <property name="ConnectionString">       "Data Source=Library.SQ3;New=True;Compress=False;Synchronous=Off;UTF8Encoding=False;Version=3"     </property>   </component>   </components> -------------------------------------- $B$3$N$h$&$J@_Dj%U%!%$%k$r:n@.$7$^$7$?!#(B $B$3$l$KBP$7$F!":n@.$7$?(BDao$B%$%s%?%U%'!<%9$N%=!<%9$O!"(B ILibraryDao.cs =========================== namespace MyS2DaoSample {     [Bean(typeof(Library))]     public interface ILibraryDao   {         Library[] GetAllLibraries();         int Insert(Library library);         int Update(Library library);         int Delete(Library library);     } } ======================================= $B$N$h$&$K$J$C$F$*$j!"(BEntity$B%/%i%9$O!"(B Library.cs =============================== namespace MyS2DaoSample{     [Table("lib_mgmt_list_tbl")]     public class Library     {         private String _libID;         private String _libName;         private String _userName;         private DateTime _creationTime;         private DateTime _lastAccessTime;         private DateTime _lastWriteTime;         public Library() {}         public String LibID  {             get { return _libID; }             set { _libID = value; }         }         public String LibName {             get { return _libName; }             set { _libName = value; }         }         public String UserName {             get { return _userName; }             set { _userName = value; }         }         public DateTime CreationTime {             get { return _creationTime; }             set { _creationTime = value; }         }         public DateTime LastAccessTime {             get { return _lastAccessTime; }             set { _lastAccessTime = value; }         }         public DateTime LastWriteTime {             get { return _lastWriteTime; }             set { _lastWriteTime = value; }         }     } } ======================================= $B$N$h$&$K$7$^$7$?!#$3$l$r(BMain$B4X?t$G(B Program.cs =============================== namespace MyS2DaoSample{     class Program {         static void Main(string[] args) {             try {                 SingletonS2ContainerFactory.ConfigPath = "App.dicon";                 SingletonS2ContainerFactory.Init();                 IS2Container container = SingletonS2ContainerFactory.Container;                 ILibraryDao libraryDao = (ILibraryDao)container.GetComponent(typeof(ILibraryDao));                 Library[] libs = libraryDao.GetAllLibraries();                 Console.WriteLine("$B=*N;(B");             }               ($BN,(B)           }        } } ======================================= $B$N$h$&$K$7$F!"(BGetAllLibraries$B%a%=%C%I$r8F$S$^$7$?!#(B $B$3$3$G!"!V%*%V%8%'%/%H;2>H$,%*%V%8%'%/%H%$%s%9%?%s%9$K@_Dj$5$l$F$$$^$;$s!#!W(B $B$H$$$&Nc30$,H/@8$7$^$9!#(BStackTrace$B$O!"(B ======================================= $B>l=j(B Seasar.Extension.Tx.Impl.TxDataSource.GetConnection() $B>l=j(B Seasar.Dao.Dbms.DbmsManager.GetDbms(IDataSource dataSource) $B>l=j(B Seasar.Dao.Impl.DaoMetaDataImpl.Initialize() $B>l=j(B Seasar.Dao.Impl.DaoMetaDataFactoryImpl.CreateDaoMetaData(Type daoType) $B>l=j(B Seasar.Dao.Impl.DaoMetaDataFactoryImpl.GetDaoMetaData(Type daoType) $B>l=j(B Seasar.Dao.Interceptors.S2DaoInterceptor.Invoke(IMethodInvocation invocation) $B>l=j(B Seasar.Framework.Aop.Proxy.AopProxy.Invoke(IMessage msg) $B>l=j(B System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) $B>l=j(B MyS2DaoSample.ILibraryDao.GetAllLibraries() $B>l=j(B MyS2DaoSample.Program.Main(String[] args) $B>l=j(B C:\Documents$B!D(B\Visual Studio 2008\Projects\MyS2DaoSample\MyS2DaoSample\Program.cs:$B9T(B 22 ======================================= $B$N$h$&$K$J$C$F$*$j$^$9!#(B $B860x$K$D$$$F!"$465<x$$$?$@$1$J$$$G$7$g$&$+!)(B</div>