All tables in my database are completely surrounded by sprocs.
The users have no access to the tables other than sprocs.
I know how to do Insert, Update and Delete using sprocs, but how do I do select ?
My goal is to use all the methods in DataContext for change management, etc.
I have created a Linq to SQL datacontext while I was logged into Oracle as schema owner.
This method in DataContext creates a "select xx from table" which is not allowed.
public Devart.Data.Linq.Table Kurveregs
{
get
{
return this.GetTable();
}
}
My idea is to change this method so it calls a sproc that returns a Kurvereg.
The return type here is but the return type from
the sproc is System.Data.Linq.ISingleResult
How can this be done?