CODE Magazine / Articles
VFP and SQL Server
Articles filed under VFP and SQL Server
Articles
Showing 1–8 of 8
-
LINQx
In this article, Yair Alan Griver introduces Microsoft's LINQ (Language Integrated Query), a framework that integrates querying capabilities directly into C# and Visual Basic, enabling unified data access across objects, databases, and XML. LINQ provides SQL-like query operators for in-memory collections and includes specialized APIs for relational data (DLinq) and XML (XLinq). Griver highlights LINQ's flexibility and ease of use, demonstrated through examples, and points readers to resources for further exploration, emphasizing its role in simplifying and unifying data manipulation within the .NET ecosystem.
-
.NET Interop for Visual FoxPro Applications
Updated
Now that .NET is here you've undoubtedly had the urge to use or at least play with the new functionality that the platform provides. Unfortunately migrating to .NET from Visual FoxPro (or most other development languages) is a big step that requires a steep learning curve. Integration between the old and the new will be crucial as a first step to provide for the ramp up time that's needed to get up to speed on the new platform as well as providing vital links between old and new applications. In this article Rick looks at the most common ways that you can use to integrate logic and data between Visual FoxPro and .NET.
-
Creating User-Defined Data Types in Yukon
ByRod Paddock
CODE Magazine · 2004 - January/February · CODE Focus Magazine · 2003 - Vol. 1 - Issue 3 - Whidbey and Yukon PDC Special · VFP Conversion Papers
Updated
The next version of SQL Server (code name Yukon) has extensive support of the Common Language Runtime (CLR).Previous versions of SQL Server (2000 and earlier) had a mechanism for creating custom data types. These data types were nothing more than aliases to system data types. In Yukon, you can create your own fully functional custom data types.
-
Handling SQL Server Errors in Nested Procedures
Basic error handling in SQL Server's programming language, Transact-SQL, is straightforward.But when you nest calls to stored procedures, and the procedures have SQL transactions, error handling becomes much more complex. In this article I'll show you some tried-and-true models for how to handle errors in nested stored procedures with transactions.
-
Implementing Two-Way Control Binding for Web Forms
ASP.NET has considerably raised the bar for Web development with very rich developer functionality built into a flexible and highly extensible object model.If you have a background of hand-coding ASP or other scripting or CGI-style technology, .NET's redundant code reduction and development process simplification seems almost too good to be true. But data binding for controls leaves a lot to be desired in terms of ease-of-use and reading the data back into the data source. This article examines what's wrong with simple data binding and provides a set of subclasses, making data binding a lot quicker and requiring much less manual code.
-
Modern Application Development: Visual FoxPro and .NET
Updated
Markus Egger argues that while Visual FoxPro remains a productive, reliable choice for monolithic, file‑based database applications, modern requirements — web services, security, scalability, disconnected/offline support, mobile devices, rich UIs, and simplified deployment/versioning — favor the .NET platform; he recommends continuing to use VFP where appropriate but adopting or migrating to .NET for distributed, service‑oriented, and Longhorn/XAML‑centric solutions.
-
Scripting SQL Server 2000 Indexes
Adding indexes to tables is the most effective way to optimize your SQL Server query performance. Tables that you query often may require several indexes in order to handle the various search arguments you send. There is one particular situation where indexes on large tables are a hindrance, though. When you're bulk-copying data into the table, it's best to have either no index at all, or just a clustered index. For those situations it is best to use Transact-SQL scripts to remove and add those indexes. In this article you'll learn how to use Transact-SQL stored procedures to generate Transact-SQL indexing scripts that are more robust and less laborious than SQL Server's Enterprise Manager scripting tool.
-
SQL Server 2000 Replication 101: Terminology, Types, and Configuration
Replication figures as one of the more prominent features of SQL Server 2000.Replication is a complex application that uses a combination of stored procedures and executables to distribute and copy data between SQL Server databases. If you take care not to get lost in the details and confused by occasionally misleading terms, replication can be an important component in the database architecture of a SQL Server application. In this article, you'll learn about the terminology surrounding replication, the types of replication available in SQL Server, and how to configure (that is, install) replication.