procedures

“procedures” is a predefined collection of references for the procedures in the database with additional properties. You can iterate tables inside a for loop to generate code using table references.

 

Sample Implementation

Input

// ICommonService.java.zsif

import java.util.List;
public interface ICommonService
{
public partial interface ICommonService
{
for(((item:procedures))){{{
List<[[[item.name]]]> GetAll();

[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Output

// ICommonService.java
import java.util.List;
public interface ICommonService
{
List<Products> GetAll();

Products Get(int ProductID);

List<Categories> GetAll();

Categories Get(int CategoryID);

List<Orders> GetAll();

Orders Get(int OrderID);
}

Input

// ICommonService.cs.zsif
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
for(((item:procedures))){{{
[OperationContract]
List<[[[item.name]]]> GetAll();
[OperationContract]
[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Output

// ICommonService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);

[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);

[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
}
}