LINQ For Dummies


Book Description

If you’ve asked yourself “Why can’t I develop database and XML queries in a language I already know?”, then Language INtegrated Query, or LINQ, is for you. LINQ For Dummies introduces you to LINQ and the .NET Framework technologies, so you can use LINQ to query any object, any data set, any kind of XML, and SQL Server—no questions asked. This plain-English guide gives you a thorough overview of LINQ, from understanding the tasks it performs to making LINQ work with both Visual Basic and Visual Studio 2005. It explains the four LINQ providers in the .NET Framework, the easiest ways to go about accessing data, and how to write more efficient applications with less code using LINQ. There’s also clear guidance on combining third-party providers with LINQ to create even more powerful apps. With this single, comprehensive guide, you’ll discover how to: Use one query language with all Microsoft languages Examine .NET language extensions and work with extension methods, partial methods, lambda expressions, and query expressions LINQ to DataSet operators, SQL server operations, XML API, or Active Directory Deal with databases — download and install the Northwind database, generate Northwind entity classes, and create the Northwind XML mapping file Create the partial class example, the partial method example, and the database modification example Use objects with LINQ Query databases in Visual Basic and C# As an added bonus, you can visit the companion Web site for LINQ examples in C# and Visual Basic. With LINQ For Dummies, you’ll link up with LINQ in no time and see how you can query almost anything! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies


Book Description

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!




Visual Basic 2008 For Dummies


Book Description

Visual Basic is a favorite programming language, so if you’re new to programming, it’s a great place to start. Visual Basic 2008 For Dummies is the fun and easy way to begin creating applications right away while you get the hang of using the Visual Studio environment. Soon you’ll be building all sorts of useful stuff with VB 2008! This step-by-step guide walks you through a logical series of tasks that build your skills as you get comfortable with .Net terminology, theory, tools, and design principles. You’ll learn how to build an application in four different architectural styles, and you’ll find out how to make your programs validate input and output, make decisions, and protect themselves from security threats. Discover how to: Install the Visual Studio environment Write a VB program Use Web forms, Windows forms, and Web services Establish good programming practices Create class libraries Write secure applications Debug your applications Work with strings and “if-then” statements Iterate with counted and nested loops Pass arguments and get return values Access data with VB.NET Work with the file system using VB You’ll also find great tips for working with the VB user interface, using VB.NET in C# programming, troubleshooting your VB programs, taking your programming to the next level, and more! Once you get your hands on Visual Basic 2008 For Dummies, you’ll be programming like a genius in no time!




ASP.NET 3.5 For Dummies


Book Description

Did you volunteer to create a Web site for the softball team? Is it time to take your small business to the next level and let your customers shop online? Well, you can relax! ASP.NET 3.5 makes creating a dynamic site faster and cleaner than ever before, and ASP.NET 3.5 For Dummies makes it easier. First, you’ll get an introduction to all the tools and terminology you need to understand ASP.NET. If you’ve used earlier versions of ASP.NET and Visual Web Developer, you can probably skip that part and jump right into what’s new in 3.5. You'll make friends with LINQ and SQL, create sites in Visual Web Developer 2008 Express, and much more. Before you know it, you’ll discover how to: Integrate data, track shopping cart contents, and whisk away bugs Create user interfaces with easy navigation Use the ListView control for sophisticated formatting Write LINQ queries Add a table to a database Create an event handler Take advantage of the drag 'n' drop feature that lets you write less code Put all the features to work to develop dynamic Web applications The softball team is going to love that Web site, and your customers might enjoy shopping on your site so much that you’ll have to expand your business to fill all the orders! We can’t promise that, of course, but we’re pretty sure that ASP.NET 3.5 For Dummies will make creating Web sites easier and a lot more fun.




Visual Studio 2010 All-in-One For Dummies


Book Description

A comprehensive, easy-to-understand guide to Visual Studio 2010 Visual Studio is Microsoft's comprehensive development environment that encompasses the .NET Framework, various programming languages, and ASP.NET. Programmers love it for developing applications for mobile devices and the Web. Because Visual Studio can be complex, the All-in-One For Dummies format makes it easy for beginners to grasp its different parts and get up to speed. Visual Studio is a development environment used with various programming languages to create a variety of applications, including those for the Web and mobile devices The updated Visual Studio 2010 features new emphasis on development for Windows 7, cloud computing, and enhanced Web and Silverlight Visual Studio 2010 All-in-One For Dummies shows how to build applications using the enhanced productivity features of Visual Studio 2010 Minibooks cover a Visual Studio overview, getting started, building Windows 7 and cloud applications, data access, coding, and other IDE details Ideal for new programmers or Java programmers who want to become proficient with Visual Studio Visual Studio 2010 All-in-One For Dummies provides both a great instruction book for new programmers and a valuable reference for the more experienced.




Visual Studio 2008 All-In-One Desk Reference For Dummies


Book Description

Visual Studio 2008 is packed with features that help you create better software and do it with less repetition and drudgery. Visual Studio 2008 All-In-One Desk Reference For Dummies shows you how to make the most of this cool suite of tools! It’s all here! This comprehensive, seven-books-in-one guide gets you up and running with Visual Studio 2008 in no time. You’ll discover Microsoft’s vision for Visual Studio, get familiar with the .Net environment and languages, and learn how to install, browse, and make connections with Visual Studio. Soon, you’ll be building applications for Vista, Office 2007, and mobile devices; using AJAX and LINQ; and testing and debugging your programs. Discover how to: Understand Visual Studio’s role in software development Work with .Net languages Develop applications for Vista Build smart client interfaces Use the visual data designer Use Ajax controls Streamline application deployment Debug your applications Explore ASP. NET services Work with strongly typed data sets Access data with Visual Studio Program with Visual Studio 2008 Build professional reports with Crystal Reports Fully updated with new information on Vista and .NET Framework 3.0 development, MS Office application development, and more, Visual Studio 2008 All-In-One Desk Reference For Dummies also features a companion Web site packed with sample projects, supplemental podcasts, and a support forum. You’ll never find a smarter way to get up to speed with Visual Studio 2008!




C# 2008 For Dummies


Book Description

Whether you’re a total novice or a programmer shifting to C#, the newest version of this programming language is full of cool features you’ll want to use. With its Visual Studio compatibility, C# is the perfect language for building Windows Vista applications. And the 2008 version works with LINQ, a query language with syntax similar to SQL but which simplifies database code and can also write queries on XML files. For the best basic C# how-to, it’s hard to beat C# 2008 For Dummies. This plain-English guide to programming with C# can have you creating your first console application before you finish Part I. In fact, the basic template you create at that point will be the foundation of many other apps as you move through the book. Along the way you’ll get the scoop on organizing your data, object-oriented programming (also known as OOP), and a great LINQ-related feature called delegates and events. You’ll find out how to Create a console application template Perform logical comparisons Work with loops and if statements Understand collection syntax Use interfaces and object-oriented concepts Apply delegates and events, and much more You’ll even gain some rare insight into how to understand error messages you may get when programming in C#. All the code you need can be found on the companion Web site, along with great bonus information that helps you do more with C# 2008. So — what are you waiting for? Grab C# 2008 For Dummies and let’s get started!




Essential LINQ


Book Description

“Charlie and Dinesh bring important skills to this project that enable them to show how LINQ works and the practical ways you can use it in your daily development process.” From the Foreword by Anders Hejlsberg LINQ is one of Microsoft’s most exciting, powerful new development technologies. Essential LINQ is the first LINQ book written by leading members of Microsoft’s LINQ and C# teams. Writing for architects, developers, and development managers, these Microsoft insiders share their intimate understanding of LINQ, revealing new patterns and best practices for getting the most out of it. Calvert and Kulkarni begin by clearly explaining how LINQ resolves the long-time “impedance mismatch” between object-oriented code and relational databases. Next, they show how LINQ integrates querying into C# as a “first-class citizen.” Using realistic code examples, they show how LINQ provides a strongly typed, IntelliSense-aware technology for working with data from any source, including SQL databases, XML files, and generic data structures. Calvert and Kulkarni carefully explain LINQ’s transformative, composable, and declarative capabilities. By fully illuminating these three concepts, the authors allow developers to discover LINQ’s full power. In addition to covering core concepts and hands-on LINQ development in C# with LINQ to Objects, LINQ to XML, LINQ to SQL, and LINQ to Entities, they also present advanced topics and new LINQ implementations developed by the LINQ community. This book • Explains the entire lifecycle of a LINQ project: design, development, debugging, and much more • Teaches LINQ from both a practical and theoretical perspective • Leverages C# language features that simplify LINQ development • Offers developers powerful LINQ query expressions to perform virtually any data-related task • Teaches how to query SQL databases for objects and how to modify those objects • Demonstrates effective use stored procedures and database functions with LINQ • Shows how to add business logic that reflects the specific requirements of your organization • Teaches developers to create, query, and transform XML data with LINQ • Shows how to transform object, relational, and XML data between each other • Offers best patterns and practices for writing robust, easy-to-maintain LINQ code




Professional Windows 7 Development Guide


Book Description

Demystify the move from Windows XP to Windows 7! Professional Windows 7 discusses all of the major new features in Windows 7, describes why the developer would want to use them, investigates the user implications of these new features, and then shows how to develop applications using them. This book focuses on the practical—which features does the developer need to know about immediately to gain the most value from Windows 7. The goal is to create a book that doesn’t waste a lot of pages on fluff or features that the developer will never use. The developer will be able to go to a particular chapter, determine what a new technology requires to use, and the use the sample application as a basis for moving applications to Windows 7 or to create new applications that use Windows 7 features. Describes all the new user interface features and shows how to use them. Demystifies the security features that Windows 7 provides. Shows how to develop efficient applications that rely on 64-bit techniques and parallel processing. Demonstrates the strength of Windows PowerShell and how to create applications for it.




SQL For Dummies


Book Description

Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease. Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems Find great examples on the use of temporal data Jump right in—without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.