C# (CSharp) GetResInfo_Result Exemples

Exemple #1

Fichier : RestaurantsController.cs Projet : Malodeity/UberEats

        public IEnumerable <ResDetails> getInfo()
        {
            GetResInfo_Result oj = new GetResInfo_Result();
            var result           = db.Database.SqlQuery <ResDetails>("SELECT ResName,ResAddress,ResCity,Image FROM dbo.Restaurant a, dbo.Picture c WHERE a.ResId = c.RestaurantId");

            return(result);
        }

Exemple #2

        public IEnumerable <ResDetails> getInfo()
        {
            GetResInfo_Result oj = new GetResInfo_Result();
            var result           = db.Database.SqlQuery <ResDetails>("SELECT res_Name,res_Location,Cuisne_Type,Image FROM dbo.Restaurant a, dbo.tblRes c WHERE a.ResId = c.RestId");

            return(result);
        }