Pharaoh Software home | tour | download | order | support | about

ADO.NET Express

There are a lot of code generators on the market that claim they will generate the whole application for you without any coding. Or they will generate data access classes so that you will never have to deal with SQL and ADO.NET.

Perhaps, you tried some of them and thought "well... they might be useful in certain scenarios...". But for your project they are too inflexible, have too many limitations and they are too complex to use.

Introducing ADO.NET Express

ADO.NET Express is an add-in for Visual Studio 2003 that automates common tasks of writing repetitive data access code. ADO.NET Express generates class methods for calling stored procedures and executing common types of SQL statements.

ADO.NET Express looks similar to Server Explorer. You can add database connections and browse schema objects such as tables and stored procedures. You can right click on a schema object to generate ADO.NET code for this object. For example, you can right-click on a stored procedure and generate a C# method that executes the stored procedure and returns a DataReader. ADO.NET Express is especially useful for ASP.NET and middleware developers who write a lot of data access code and would like to save time to do more creative tasks. Generated code is easy to understand and modify. ADO.NET Express has a variety of options for generating code that cover most of the common data access scenarios. Generated code can also be used as a template for modification.

ADO.NET Express


take a tour | download FREE Lite version | buy Pro version for $99.95


take a tour | download FREE Lite version | buy Pro version for $99.95

Lite and Professional versions

ADO.NET Express is available in two versions Lite and Professional. Lite version lets you evaluate all features of Professional version for a period of 30 days. After that some code generation features will be disabled but you can continue using Lite version for free as long as you wish.

This table describes the differeneces between versions:
Feature Lite Professional
Cost FREE $99.95
Code generation for tables, views, foreign keys and stored procedures limited, some method templates are not available full
Code generation in C# yes yes
Code generation in Visual Basic.NET yes yes
Support for SQL Server yes yes
Support for Oracle yes yes
Using .NET types for method parameters yes yes
Using provider specific types for method parameters no yes
Handling output and input/output parameters of stored procedures yes yes
Connection string hardcoded in generated code yes yes
User can specify how connection string is obtained no yes
Generated code supports transactions no yes
Number of database objects per schema 20 unlimited

Latest News

The protection of personal data in the development of applications

Under this motto, the “Good Practices Guide for the development of Apps” was developed. The document was supported by the Sadosky Foundation and was presented today at the Technological Science Center.

The Sadosky Foundation, a subsidiary of the Ministry of Science, Technology and Productive Innovation, delta extranet and the National Directorate for the Protection of Personal Data of the Ministry of Justice and Human Rights, presented the “Good Practices Guide for the development of Apps” developed in collaboration with ICT Security Program of the Foundation. The launch took place this afternoon in the cafeteria of the Scientific Science Center, headquarters of the Ministry of Science, and was in charge of the national director of Personal Data Protection of the Justice portfolio, Juan Cruz Gonzalez Allonca; And the director of the ICT Security Program of the Sadosky Foundation, Ivan Arce.

During the meeting, the main recommendations included in the document, addressed mainly to the application developers, who are responsible for ensuring the privacy of the personal data used by its software, under Law 25.326 (Law on Protection Of Personal Data) that establishes principles and obligations regarding the processing of data. In this regard, Arce emphasized that “if we understand security as an attribute of software quality and the processing of personal data as an indicator, the Guide we are presenting provides the tools necessary to tackle possible problems associated with failures protection of privacy before they arise “ .

The guide is based on a series of procedures to take into account, from the very beginning of the application development, to establish a clear and transparent data use policy that allows the holders of these data to know how the treatment is Which applications perform on your information. In addition, the contents include technical and methodological aspects to consider and basic steps are offered to safeguard the privacy of users in relation to the quantity and quality of the data being handled.

Finally, the document includes specifications for the development of mobile applications and for those intended to be used by children and adolescents, general data, contact data and consultation of the National Directorate for the Protection of Personal Data and a summary of law 25.326 for To be able to know its scope, and the general principles that it establishes regarding the protection of personal data and its treatment.

A developer gets Android Wear made compatible with iOS

Unless reaches one year of life, Android Wear is still not compatible with other platforms besides Android , and that may seem logical, the fact is that Google has always been very open to other platforms, so it is curious that have not tried somehow or other it compatible with iOS.

The truth is that on more than one occasion have dared to say that e n the future we will see this compatibility, although iOS as being denied as when giving permissions to other platforms …, it may take a little longer.

But leaving aside the official movements of Google, one desarrolldor of Android Wear has achieved this compatibility . Mohammad Abu-Garbeyyeh, a reputed XDA developer has made notifications reach your iPhone with Android Wear smart watch to show a short video posted on his Twitter account.

In the video we see as they arrive on the iPhone notification immediately on the watch also . In this case it uses a Motorola Moto 360, although in principle work with any smartwatch carrying Android Wear inside.

To achieve this use of ANSC is made, the notification system Apple has been implemented since iOS 7. Almost is the same used by Pebble to show notifications on your fit watches. The important thing is that has not been necessary any jailbreak on the iPhone, but theoretically works on any iPhone or iPad with iOS 7 or higher.

Obviously this is a very limited system, ie ANSC only allows you to receive notifications, you can not interact with them , and therefore can not use many functions of Android Wear. we’ll see if Apple decides to open up a bit on this , or otherwise close even more to give exclusivity to the Apple Watch. Anyway, it is a step, a small step.

Manage your library and make your own movie database

The formats of our films are varied and often have difficulty finding the DVD or Blue Ray we need in our video library or access our xmovies8 on your computer. Without delving into the issue on the support or the source of the content from the Audiovisual Documentalist we propose some tools that will serve to keep track of your collection of movies and series.

As a starting point when both physically organize our digital library as we should establish a basic order and from there begin to organize our files. In the case of movies stored on a computer or an external hard drive we can establish a system of folders based on film genres.


And from here if we need to create subfolders classified according to our needs (subgenus, director, actor …). Another aspect to consider when saving our films is that many times the file names give more information of the title, so it is important that if that information overload is not necessary files will be renamed with the title of the film as it will be easier cataloging programs can search for information such films.

In the event that our library is physically we can pool our DVD’s or Blu-Ray by the gender system.

Although it seems that this system is obsolete by new programs that we can find a network, propose this method to people who have problems to cope with unknown programs or simply do not like to download programs from the network because with these tools can create databases simple data.

As this is a manual process in which we introduce ourselves data by reducing the home field, we propose a fairly simple fields to fill.

film database

Each entry must assign a reference number especially when it comes to cataloging physical media because then we can locate our film by placing a number label. This reference number can be simple or we can add some letter that tells us which gender or year of release. As you can see in the picture we have placed some basic fields but can be extended with other data such as the cast. producer, sound, language, subtitles, caratulas … For movies that are digitally add a hyperlink that leads directly to the file.

We can see in the previous section to create a base of nonprofessional data is quite simple but internet offers a range of possibilities with different software that allow our database is easy to create and contains as much information as possible.

If we look at Google “video cataloguer” we find endless programs dedicated to this task.

Most of these programs work in a similar way:

We’ve tried a few and then we will give you a list with several of these software and what have been that we liked most.

All my movies:


Although it is a paid software is a very useful while easy to handle and install tool. As you can see in the picture above, the tab includes the most important data of film, film images, trailer access, file information, the website of the film and a play button.

The tabs are easy to refill because once introduced the title goes to the search IMDB and other data bases film. The data we do not have are very simple to introduce as you can see below.

Regarding the television series catolagoción perform the same process: we write the title and we search the online database. Once we made going to the episodes tab and can change the seasons we have and associate each episode to its corresponding file (if we had the series on the computer).


EMDB is a free software that allows us to organize our collection of films in any format and access them in a direct and simple way. From the main window EMDB have an overview as a shelf of all our movies and series.

EDBM interface

To add a new movie to the catalog you must press “Add” in the main window. a tab that can be filled manually or using IMDB appears.

“Additional information” we can complete other data.

EMDB has a simple search system as shown in the following image:


In addition to the various options that prorciona this software we can export our database  in HTML, CSV or text files.

The end result leads to a base fairly complete data, with all faults that carry this type of program when searching on the computer hard drives (as we said above, often the names of video files do not match exactly with the titles of movies), but very simple and effective once we have corrected the problems with file names.

There are similar to these programs and recommend that you consult the user reviews and probéis several of them to find the one that most suits your needs. In case you want to consult other programs or descargaros both of which we have spoken we leave this link: Putlocker

Encoding forms can help your SEO

A lot of webmasters perceive SEO in terms of things that have to do after a site is made, it would be the optimization of specific variables on the page so you can maximize the likelihood that they would be sorted by keywords or process to request specific backlinks sources who are qualified to off-page SEO.


But ignoring the important role that the page encoding could play in optimizing total necessarily be enough to make a house on a foundation that is unstable. Consider all the ways in which the coding can help SEO your site to not miss out on critical performance.

1) Validate the access code to the search engine spider.

You must keep in mind that programs search engine spider have serious limitations when climbing indexing the site. While only read text effectively, other elements of the site, including images, audio, video, and script files, you can stop all important text site indexed properly. If you see that parts of the text are bad pages, valitadate the code correctly for search engines to find information.

2) The use of encryption to SEF URL rewriting.

Make a friendly URL search engine would be beneficial from the point of view of SEO and in terms of user experience. The particular form that you would have to modify the page code so that you can minimize the number of extraneous characters more codes that would be present in the URL have a dependence on the particular platform could work on the site.

3) Clean the code to facilitate improvements in site speed.

Although the site’s code can start clean, eventually it would be common for the website modification to bring in a number of different errors that can slow your site. For this reason, it would be a good idea to make regular checks are problems.

a.Take out additional spaces, which makes the code readable

b.Utilize and HTML Validator to enter brokern more tags unpaired.

c.Utilize Broken Link Checker tool to remove URLs invalid.

4) Serve textual alternative to the script on the page.

As seen in Tip # 1, the search engine does not normally have access to information that may be contained in the image files, video or script. But, as these items could go a long way in improving the user experience on the site, it would be a good idea to take them all.

Versions, however, something better to do from the point of view of coding alternative would be to serve and text-based information that you want the search engines to index.

5) Put the tag “noindex” in the robots.txt file.

While there is no way to control the behavior of spiders of search engines with 100% accuracy will not tell the site pages indexed by the tag “noindex” in the robots.txt file can be useful from SEO point of view.The code must be added to the robots.txt file for pages that should not enter the search results, including:

one. Shopping cart and checkout pages

b. User Pages panel

c. Archive pages

d. Contact pages

6) Use “rel = canonical” to address the problems of duplicate content.

If you are using a CMS program, you will likely have duplicate content issues that arises when these platforms are URL.

Since these URLs can be redirected to the same page, you face the risk of being subjected to duplicate content filters in the search engines should not specify exactly how to treat each variation.

The best way to instruct search engines about how to handle the URL would be through the use of “rel = canonical” tag. This feature can be added to the section of the site, either by hand or by using a plugin and tell the search engines for contempt, or redirected to a page index for the specified URL.

7) in September 301 should redirect to ensure the proper flow of PageRank.

When he would come to establish appropriate 301s, there would be two situations encoding you want to search from the point of view of SEO. First, use the code to inform search engines that both www and non-www versions of the URL should be treated in the same way.

Second, if you were to move the contents of the site (for example, you should change the title of the article and blog permalink) do a 301 redirect to tell the search engines movement. This will minimize the potential loss that can occur when rank backlinks no longer solve the old URL.

8) Use Microdata for rich snippets

A final addition to the toolbox developer would microdata, a new language that allows you to put different levels to clarify the data for the HTML code of the page. Not only are these help the site indexed and classified correctly, can also increase the percentage of clicks of the SERP by creating more research in search results through rich snippets elements.

As there would be speculation that the general rates of the SERP clicks weighed as a factor in ranking, putting the new features help SEO add a site for additional traffic through search results.

9) Join the script file to speed up loading times.

Recently, the site loading speed is important as a factor in the ranking of search engines, with a base in the declared Google for rewarding to get results faster search sites desire.

Unfortunately, if you have built a site using tons of scripts to provide more functionality for visitors, charging different code files can lead to site performance substantially. Through the combination of individual code sheets into smaller files, you could get rid of load times caused by excessive demands of the script, in addition to improving the SEO of the site.

10) Use CDN to minimize the resources required to implement.

Finally, once you make all possible changes in the code of the site, and has not yet been achieved improved loading times, get a distribution network of content to provide the content of external sites to minimize the global resources needed to launch the site.

Of course, with all these technical advice to ensure that their efforts to observe the contents. Make sure the keywords are always up to date. You can do this through the KeywordSpy that allows you to spy on your competitors and know in real time the keywords that you employ. In this way, you will not run out of the loop, even how to improve the design of your site. Visit seo company bangkok for more details.

take a tour | download FREE Lite version | buy Pro version for $99.95

Copyright © Pharaoh Software, 2004. All rights reserved.
US patent pending for ADO.NET Express.