Bitboxx.DNNModules.BBImageStory.Components.DbController.GetStory C# (CSharp) Method

DbController Class Documentation Show file Open project: weggetor/BBImageStory

GetStory() public method

public GetStory ( int storyId ) : StoryInfo
storyId	int
return	Bitboxx.DNNModules.BBImageStory.Models.StoryInfo

        public StoryInfo GetStory(int storyId)
        {
            using (IDataContext ctx = DataContext.Instance())
            {
                string sqlCmd = "SELECT * FROM {databaseOwner}[{objectQualifier}" + Prefix + "Story] story WHERE storyId = @0";
                return ctx.ExecuteQuery<StoryInfo>(CommandType.Text, sqlCmd, storyId).FirstOrDefault();
            }
        }