Archive | Sci-tech

There are several different ways to view a query’s execution plan. They include: From within Query Analyzer is an option called “Show Execution Plan” (located on the Que...

We can duplicate it in office testing easily; Just shut down an MS SQL Server service while your delphi TADOConnection object is connected to a database on that server in...

No worries, after some digging I figured out how to get this to work. Create the following custom MediaTypeFormatter in your application using System; using System.IO...

When we add an Entity Data Model (*.edmx) a default connection string gets added to the solution as shown below: As indicated in the figure above the two critical compon...

It’s about noticing the look on your partner’s face that says, 'I’m having a really bad day,’ and responding to that. The small, simple actions keep love alive. It’s nice...

Drivers The following JDBC drivers are supported: MSSQL MySQL Oracle Thin Oracle OCI Sybase SQL Anywhere PostgreSQL Firebird DB2 ODBC drivers are not supported...

Using the Entity Framework, developers issue queries using LINQ, then retrieve and manipulate data as strongly typed objects. The Entity Framework’s ORM implementation pr...

It is designed to ensure data integrity. Imagine we want the SaveChanges to be only a part of more complicated update process. For example, we want to execute several Sa...

MySQL Auto Backup can be used to schedule backup one/multiple MySQL database(s) to the local SQL/PHP files, and support restore the databases by the SQL files. All MySQL ...

Sync Data either transfers the rows or generates SQL DML statements. Windows 95/98/ME/NT/2000/XP Platform: 9 MbFile Size: Free to try; $260 to buy License: Apr...

Multi Column Indexes modelBuilder.Entity<People>().Property(x => x.Firstname).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_ful...

This software will save you time because importing and exporting can be done without SQL knowledge. MS SQL Server 2000 or higher required. This program is not compatible ...

With the help of ADO.NET, database can be accessed without much required programming or code. 2) Mention what is the key advantage of using Entity Framework or EF? Th...

Inside dotConnect data providers there is Sync Framework support, support for Oracle 12c, an improved PgSqlDump component, and load-balancing support in dotConnect for My...

For each oracle package generates one unit with class that represent oracle package. Methods of this class are equivalent to oracle's package procedures and functions.

Because each entity creates dynamically. So this is what i can NOT use: http://msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic12 http://msdn.microsof...

STEP ONE FOR FIXING MSDE'S - PUT BACK THE FILES The instructions that work are as follows: In the C:\Program Files\Microsoft SQL Server SP4\WMSDE\Setup folder find...

With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database ...

Global Temp Tables, however, are not supported in Azure SQL Server. Is there a known workaround that will enable me to use the In-database tools with Azure SQL Server.

MySQL 5.0 (in development) is getting closer to PostgreSQL’s impressive feature set, with Views and Stored Procedures on the list. According to the article, however, MySQ...

Extended features provide an easier way to quickly explore databases, manage schema objects, setup user accounts and privileges, develop stored routines, and synchronize ...

Express edition is a freeware alternative to the different LINQ debug visualizers - it displays SQL and parameters for LINQ to NHibernate, LINQ to SQL, LINQ to Entities, ...

Alternative to windows explorer with smooth... zabkat.com alternate of compareandmerge.com, isn't it? Yes No 0

For MySQL you can use MySQLMembershipProvider. There is a nice article how you can setup it: How to Setup and Configure MySql Membership Provider Moreover you can use...

Note: Backup and restore is done on an entire database or entire table, and not meant for extracts of data. In that case you would use copy. Backup pg_dump is the uti...

I know you can do this using COM, but I figured it would be fun to try this using.NET. The great thing about.NET is it’s so well documented. My starting point for this ex...

IMO EF is the best one I’ve used yet. Well, I should say it is awesome MOST of the time. The biggest beef I have with it is that the models can get out of sync with the ...

The current implementation always loads all related records so if we have a main entity which has thousand related entities and we want to get only 10 most recent through...

If the volume where MongoDB stores data files supports point in time snapshots, you can use these snapshots to create backups of a MongoDB system at an exact moment in ti...

In this blog post I will outline some of the capabilities and offerings available in this space. The first place I start when answering this question is to clarify what ...

Anyway, I am debating between two approaches: 1)When a user logs in, look up from the database and store the userIdInt in a session variable and any-time session variab...

DISTICT, TOP, LIMIT and other advanced/database server-specific clauses can be set visually. User can quickly find the needed tables to by browsing the Database Shema ...

We discuss the details of using stored programs within each of these environments in Chapters Chapter 12 through Chapter 17. For now, let's look at how you can call a st...

It also contains data command objects for SQL Select, Update, and Delete statements. Other data-source controls enable you to connect to OLE-DB data sources, XML data sou...

Linq to SQL is a decent base level OR/M, and I had had several people tell me that they are willing to accept its current deficiencies, knowing that this will be fixed in...