i have program 3 tier (in 3 folders DAL,BLL,UI)
http://bayanbox.ir/id/5085234522641486493?view
in DAL definition Project Class Library and in project definition .edmx file (Entity Framework)
and created folder for Entites (definition class entites in folder).
how definition type return method in classes for show data in other layers (for pass content in BLL layer) but with use Stored Procedure
this is my code
<pre lang="c#">
private UniversityEntities DB = new UniversityEntities();
public void SelectAll()
{
DB.SPShow();
}
SPShow is name my stored procedure for show data
and in BLL folder definition project class library. after add reference DAL and name space
create class for entites.
and this is my code in class
<pre lang="c#">
public void SelectAll()
{
Student objDAL = new Student();
objDAL.SelectAll();
}
</pre>
but when call this is method (in UI layer) for display data in grid view i CAN'T
because i think doing is wrong about definition type return.
1- Please Help me .how definition return type in DAL Layer for call in BLL and UI which i can use SP?
2- and how definition method (with use Stored Procedure) which if result was true .content 1 return ?(with code in Application is better or in SQL Server)