Hi,<br><br>Thanks for your immediate reply.<br><br>I have gone through the samples.I am trying to call these functions from windows application.<br>Am using SQLServer Database.<br><br><br>my App.config file<br><br><quill><br>
<dataSources><br> <dataSource name="ExampleDB"><br> <provider>SqlServer</provider><br> <connectionString>"server=AGTNB15;user id=sa; password=angels; database=pmsdb-client;"</connectionString><br>
<class>Seasar.Extension.Tx.Impl.TxDataSource</class><br> </dataSource><br> </dataSources><br> <!--<assemblys><br><pre class="csharpcode"><assembly>Oracle.DataAccess, version=10.2.0.100, Culture=neutral, <br>
PublicKeyToken=89b483f429c47342</assembly><br> </assemblys><br></pre>--><br> </quill><br><br>In that documents it is mentioned that the assembly is needed only if i use other than Sqlserver.<br>
<br><br><b> QuillInjector.GetInstance.Inject(Me)</b><br><br>when i call this function it throws FilenotFoundException<br><br>$B%U%!%$%k$^$?$O%"%;%s%V%j(B 'Castle.DynamicProxy, Version=1.1.5.0, Culture=neutral, PublicKeyToken=f362209d9bee91d8'$B!"$^$?$O$=$N0MB84X78$N(B 1 $B$D$,FI$_9~$a$^$;$s$G$7$?!#;XDj$5$l$?%U%!%$%k$,8+$D$+$j$^$;$s(B.<br>
<br>This is the Exception i got.<br><br>Any other settings i missed here?<br><br>Thanks in Advance.<br>Thomas.<br><br> <br><br><br><div class="gmail_quote">2010/6/7 kubo <span dir="ltr"><<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hello,<br>
<br>
At first, DB settings are in App.config<br>
<br>
// App.config example of dfnet-basic-example<br>
<a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExampleTest/App.config" target="_blank">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExampleTest/App.config</a><br>
<br>
<quill><br>
<dataSources><br>
<dataSource name="xxx"><br>
<provider>xxx</provider><br>
<connectionString>"xxx"</connectionString><br>
<class>Seasar.Extension.Tx.Impl.TxDataSource</class><br>
</dataSource><br>
</dataSources><br>
<assemblys><br>
<assembly>xxx</assembly><br>
</assemblys><br>
</quill><br>
<br>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>
And there is an example of "<a href="http://ASP.NET" target="_blank">ASP.NET</a> + DBFlute.NET".<br>
Please refer to the example, and you can get<br>
a way to call those classes.<br>
(Even if you don't use <a href="http://ASP.NET" target="_blank">ASP.NET</a>, it is so beneficial)<br>
<br>
// dfnet-asp.net-example<br>
<a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example" target="_blank">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example</a><br>
<br>
// MemberList.aspx.cs (uses QuillInjector at the constructor)<br>
<a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example/source/DfExampleWeb/View/Member/MemberList.aspx.cs" target="_blank">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example/source/DfExampleWeb/View/Member/MemberList.aspx.cs</a><br>
<br>
// MemberFacade.cs (called by <a href="http://asp.net" target="_blank">asp.net</a> class and uses Behavior)<br>
<a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example/source/DfExampleBiz/Facade/Member/MemberFacade.cs" target="_blank">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-asp.net-example/source/DfExampleBiz/Facade/Member/MemberFacade.cs</a><br>
<br>
Call-path is as follows:<br>
MemberList.aspx<br>
--> MemberFacade.cs<br>
--> MemberBhv.cs<br>
<br>
DBFlute.NET uses Quill.<br>
It's simple DI container without setting files.<br>
(similar to Google Guice in Java)<br>
<a href="http://s2container.net.seasar.org/ja/quill.html" target="_blank">http://s2container.net.seasar.org/ja/quill.html</a><br>
<br>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>
MemberFacade and MemberBhv are DI component (of Quill).<br>
If a class has an [Implementation] attribute, it means DI conponent.<br>
<br>
[Implementation]<br>
public class MemberFacade ...<br>
<br>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>
And MemberFacade.Update() method has a [Transaction] attribute.<br>
It means the method is in transaction scope.<br>
Only a DI component can use the [Transaction] attribute.<br>
(And then the method must be virtual)<br>
<br>
[Transaction]<br>
public virtual void Update(MemberDto dto)<br>
<br>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>
MemberList is not (cannot be) DI component<br>
so MemberList needs to inject myself by QuillInjector<br>
at the constructor for calling DI component classes.<br>
<br>
protected MemberFacade facade; // injected by Inject(this);<br>
public MemberList() {<br>
QuillInjector.GetInstance().Inject(this);<br>
}<br>
protected void Page_Load(object sender, EventArgs e) {<br>
... = facade.GetMemberList();<br>
}<br>
<br>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>
<br>
Thanks<br>
jflute<br>
<br>
2010/6/7 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>:<br>
<div><div></div><div class="h5">> Hi,<br>
><br>
> Now am able to create C# classes using dbflute with SQLServer.<br>
> Now i want to use these classes in my application.<br>
><br>
> What are the setting files i have to write for calling these classes.<br>
> (like jdbc.dicon in java)<br>
><br>
> Thanks in advance.<br>
> Thomas<br>
><br>
><br>
> 2010/6/5 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>><br>
>><br>
>> Hello thomas<br>
>><br>
>> Please retry by dbflute-0.8.9.17-01-SNAPSHOT.zip.<br>
>> You can get more detail messages of SQLException.<br>
>><br>
>> Download it from this page:<br>
>> <a href="http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html" target="_blank">http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html</a><br>
>><br>
>> Thanks<br>
>> jflute<br>
>> _______________________________________________<br>
>> seasar-dotnet mailing list<br>
>> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
><br>
><br>
> _______________________________________________<br>
> seasar-dotnet mailing list<br>
> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
><br>
><br>
_______________________________________________<br>
seasar-dotnet mailing list<br>
<a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
<a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
</div></div></blockquote></div><br>