Telerik blogs

Latest

  • Productivity

    Create a SQL Azure CRUD Application with Telerik OpenAccess and the WCF Wizard

    digg_url = "http://www.stephenforte.net/PermaLink,guid,a7d16ce5-33d4-475b-bb5a-32d38c2a99b4.aspx";digg_title = "Create a SQL Azure CRUD Application with Telerik OpenAccess and the WCF Wizard";digg_bgcolor = "#FFFFFF";digg_skin = "normal";digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined; Over the past few weeks I have showed how to use Telerik OpenAccess with the WCF Wizard. I think that this wizard is a crucial piece of technology since I hate to write plumbing code myself, it takes me too long and I usually make mistakes. I wish that SQL Azure would provide RESTful and WCF services wrapped around your database tables and views with just a check box in the Azure management page. But alas, I can dream. Until that day arrives, you will have to code the services yourself. So I decided to do it with OpenAccess and WCF (and of course the Wizard.) First you...
    May 27, 2021 8 min read
  • Productivity Reporting

    Filtering with string parameter that allows free user input

    As you probably know, Telerik Reporting comes with built-in parameters and filters. Report parameters allow users to specify or control the data used in a report. They are extremely powerful when used in expressions for filtering, sorting, grouping or even directly provide a value. When used with filters you can limit the number of records in a report based on specified filter rules. If the conditions of the rules are met, the record is included in the report.  Let's suppose we have a string parameter that allows free user input, wired up with a filter. This way the user has the freedom to type any word and the report would be filtered based on the parameter...
    May 27, 2021 2 min read
  • Productivity

    Telerik OpenAccess WCF Wizard: How-to Video #6-Auto detection of OpenAccess Version

    digg_url = "http://www.stephenforte.net/PermaLink,guid,c2e16168-facc-4bdd-a86e-406b9367bdb8.aspx";digg_title = "Telerik OpenAccess WCF Wizard: How-to Video #6-Auto detection of OpenAccess Version";digg_bgcolor = "#FFFFFF";digg_skin = "normal";digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined; As I showed yesterday, the new version of the Telerik OpenAccess WCF Wizard now allows you to work with any version of OpenAccess. Here is a video of how to do that by .NET Ninja in training Peter Bahaa. Telerik OpenAccess WCF Wizard: How-to Video #6-Auto detection of OpenAccess Version from Stephen Forte on Vimeo.
    May 27, 2021 1 min read
  • Productivity

    LINQ Tip of the week: System.DateTime support

    Continuing with the LINQ tips, today we provide a list of System.DateTime properties and methods that are supported by the Telerik OpenAccess ORM LINQ implementation. The table below provides the equivalent SQL function call for every member.   Please note that the table lists the MS SqlServer specific SQL translation.   Properties DateTime.Day DAY(date) DateTime.Hour DATEPART(hour, date) DateTime.Millisecond DATEPART(millisecond,date) DateTime.Minute DATEPART(minute, date) DateTime.Month MONTH(date) DateTime.Second DATEPART(second, date) DateTime.Year YEAR(date)   Static Methods DateTime.Parse(String) value is parsed on the client side and the result is pushed to the server as filter DateTime.Parse(String,IFormatProvider) value is parsed on the client side and the result is pushed to the server as filter DateTime.Parse(String,IFormatProvider,DateTimeStyles) value is parsed on the client side and the result is pushed to the server as filter   The various comparison operators...
    May 27, 2021 1 min read
  • Productivity

    Using the Telerik OpenAccess WCF Wizard with Multiple Versions of OpenAccess

    digg_url = "http://www.stephenforte.net/PermaLink,guid,650656ff-6523-40cf-9ea3-ea027824e72b.aspx";digg_title = "Using the Telerik OpenAccess WCF Wizard with Multiple Versions of OpenAccess";digg_bgcolor = "#FFFFFF";digg_skin = "normal";digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined; When the Telerik OpenAccess WCF Wizard shipped last month, it only worked with the Q2 version of OpenAccess. The problem is that Telerik makes internal builds of a product available in-between releases so developers can play around with new bits faster-and the OpenAccess WCF Wizard did not work with them. Telerik Internal Builds fix bugs out of band so lots of folks us them. The feedback we got on the WCF Wizard is that the wizard should work with any version of OpenAccess, including internal builds. The latest version of the Telerik OpenAccess WCF Wizard does just that. Now when you open the Wizard and you attempt to connect to...
    May 27, 2021 1 min read