Devart Forums

Code: Select all

DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetNetworkElementData`( 
                                     IN Id INT, 
                                     OUT ParentLink INT, 
                                     OUT Number INT  , 
                                     OUT Name TEXT  , 
                                     OUT TimeStamp nvarchar(50)  , 
                                     OUT AddressType_Descr nvarchar(50)    
                                     )
BEGIN    
                                     select 
                                     NetworkElement_Number as Number, 
                                     Lnk_Omse_Networkelements as ParentLink, 
                                     NetworkElement_Name as Name, 
                                     NetworkElement_TimeStamp as TimeStamp, 
                                     NetworkElement_AddressType_Descr as AddressType_Descr 
                                     from Omse_Networkelements, Omse_Networkelement_Types, Omse_Networkelement_Addresstypes  
                                     where   Omse_Networkelements.NetworkElement_Id = Id  AND 
                                     Omse_Networkelement_Types.NetworkElement_Type_Id = Omse_Networkelements.Lnk_Omse_Networkelement_Types 
                                     AND 
                                     Omse_Networkelement_Addresstypes.NetworkElement_AddressType_Id = Omse_Networkelement_Types.Lnk_Omse_Networkelement_Addresstypes; 
                                     END ;;
DELIMITER ;

Code: Select all

   [Function(Name=@"sp_GetNetworkElementData")]
        public Devart.Data.Linq.ISingleResult<Sp_GetNetworkElementDataResult> Sp_GetNetworkElementData([Parameter(Name="Id", DbType="INT(10)")] System.Nullable<int> Id, [Parameter(Name="ParentLink", DbType="INT(10)")] out System.Nullable<int> ParentLink, [Parameter(Name="Number", DbType="INT(10)")] out System.Nullable<int> Number, [Parameter(Name="Name", DbType="TEXT")] out string Name, [Parameter(Name="TimeStamp", DbType="VARCHAR(50)")] out string TimeStamp, [Parameter(Name="AddressType_Descr", DbType="VARCHAR(50)")] out string AddressType_Descr)
        {
            IExecuteResult _Sp_GetNetworkElementDataResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), Id, (System.Nullable<int>)null, (System.Nullable<int>)null, (string)null, (string)null, (string)null);
            ParentLink = ((System.Nullable<int>)(_Sp_GetNetworkElementDataResult.GetParameterValue(1)));
            Number = ((System.Nullable<int>)(_Sp_GetNetworkElementDataResult.GetParameterValue(2)));
            Name = ((string)(_Sp_GetNetworkElementDataResult.GetParameterValue(3)));
            TimeStamp = ((string)(_Sp_GetNetworkElementDataResult.GetParameterValue(4)));
            AddressType_Descr = ((string)(_Sp_GetNetworkElementDataResult.GetParameterValue(5)));
            return ((Devart.Data.Linq.ISingleResult<Sp_GetNetworkElementDataResult>)(_Sp_GetNetworkElementDataResult.ReturnValue));
        }