CREATE PROC [dbo].[GetRolesForUser](@UserID int) as Select A.id,cast(iif(ISNULL(b.id,0)>0,1,0) as bit) as IsChecked, A.UserRoleName From tblRole A LEFT JOIN tblUserRoles B on (A.id=b.RoleId and B.UserID=@UserID)
vmsUri = new Uri("http://localhost:2233/iRentDataService.svc/"); db = new iRentEntities(vmsUri); //var query = db.CreateQuery<GetRolesForUser_Result>("GetRolesForUser") // .AddQueryOption("userid", 6); var query = db.Execute<GetRolesForUser_Result>(new Uri(string.Format("{0}GetRolesForUser?userid={1}", db.BaseUri, 6), UriKind.RelativeOrAbsolute)); GetRolesForUser_Result gc = new GetRolesForUser_Result(); config.SetServiceOperationAccessRule("GetRolesForUser", ServiceOperationRights.All); <pre lang="xml"> this way i exposed dataservice : [WebGet] public IQueryable<GetRolesForUser_Result> GetRolesForUser(int userid) { return this.CurrentDataSource.GetRolesForUser(userid).AsQueryable < GetRolesForUser_Result>(); //.GetRolesForUser(userid).AsQueryable<GetRolesForUser_Result>(); //return this.CurrentDataSource.GetRolesForUser.where("it.userid=@userid", new ObjectParameter("userid", userid)); //.GetRolesForUser(userid) //.AsQueryable(); } </pre> The result is coming in browser : <a href="http://localhost:2233/iRentDataService.svc/GetRolesForUser?userid=6"> how an i call at client side and bind to datagrid ..please help..thanx
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)