Database Software Development Videos and Tutorials: MySQL, Oracle, NoSQL
With any new technology, performance implications are important to consider. If you want to get the best performance from Entity Framework queries, you should use the Compile function of the CompiledQuery class. This video demonstrates how to use compiled queries in the Entity Framework. http://msdn.microsoft.com/en-gb/vcsharp/dd565858.aspx
In the course of six months IMVU’s user base quadrupled in size. At the start of this period we were bottlenecked on a single central database. During these six months we evolved IMVU’s architecture to use caching with memcached, replication, horizontal and vertical partitioning to support this growth. We’ll look …
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone? The TIMESTAMP data type will show different times if you change the server’s time zone. This presentation covers all …
ADO.NET Entity Framework is an object-relational mapping (ORM) framework for Microsoft .NET. In this video, Todd Miranda explores how to use the Entity Framework to access and manipulate data from a database. http://msdn.microsoft.com/en-gb/vcsharp/dd565857.aspx
Tiw webcast shows some exciting new features that turn LINQPad into an essential tool for writing and performance-tuning Entity Framework queries.
A presentation of the dynamic SQL statements for Informix.