database function

[oishiimendesu]

Hello, Can I use auto-interface for executing sql functions, like this:

public interface IBeerRepository { [Sql("fn_CountCustom")] void CountCustom(Beer beer); }

or something like that.

[jonwagner]

I don't remember if that was ever implemented.

You can try:

[Sql("fn_CountCustom", CommandType.SqlFunction)]

[oishiimendesu]

I don't remember if that was ever implemented.

You can try:

[Sql("fn_CountCustom", CommandType.SqlFunction)]

thanks

[Jaxelr]

Is it SQL Server the DB? This would work:

public interface IBeerRepository
{
   [Sql("SELECT dbo.fn_CountCustom()")]
   void CountCustom();
}

[oishiimendesu]

I don't remember if that was ever implemented.

You can try:

[Sql("fn_CountCustom", CommandType.SqlFunction)]

this doesn't work, because CommandType.SqlFunction not exists.

[Jaxelr]

Closing, if you have any other issues with this snippet reopen issue.

Thanks.