Getting Started with LINQ(beyondrelational.com)

submitted by DPalkar(228) 1 year, 9 months ago

In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before that it surely requires a good introduction to start with. LINQ was introduced with .net 3.0 as one of the language enhancements. It uses generics, which was introduced in .net 2.0, thoroughly to accomplish what it was designed to do. LINQ is designed to query virtually any kind of data source which implements IEnumerable<T> interface. It allows you to query the data by emulating the SQL query expressions using any .net language you are comfortable with. Isn’t that amazing!! read more...

add a comment |category: Linq |Views: 344

tags: SQL Query getting Expressions Started another

Dynamic Group and Where clauses in LINQ queries.(dotnet.org.za)

submitted by craigtp(683) 2 years, 11 months ago

A very elegant way to achieve dynamic where and group clauses in LINQ queries. read more...

add a comment |category: Linq |Views: 237

tags: Query dynamic LINQ another

NHibernate Query Analyzer for NHibernate 1.2 GA(ayende.com)

submitted by leniel(489) 3 years, 2 months ago

NHibernate Query Analyzer is a tool to allow you to pick into the internal of NHibernate guts. The current feature set offers: * The ability to view the results from an HQL query in both tabular and object graph formats. * Support for lazy collections. * On the fly error checking for HQL statements. * Support for parametrized queries. * Smart error checking for schema violations and helpful messages about how to fix them. * The editors for configuration and mapping files are both more pleasing to the eye and much better in regard to such things as accurate error reporting. * The editors will try to help you when they know what kind of information you should input to the class. * Using NHiberante 0.8.4, the latest released package. If you don't know what NHiberante is: NHibernate is an object to relational library based on Java's Hibernate that takes much of the burden of routine data access from the developer. read more...

add a comment |category: Database |Views: 105

tags: Query Analyzer Database NHIbernate another

SubSonic of the Day - They Query Tool(weblogs.asp.net)

submitted by zowens(988) 4 years, 4 months ago

By now, you have probably heard of LINQ. LINQ, as you probably know, stands for Language Integrated Query. The LINQ queries you build inside of C# or VB are baked into the .NET 3.5 framework. SubSonic takes a more traditional approach (right now) and uses the Query as an object. Instead of doing weird things like var myQ = from.... and Dim myQ = Select..... you create an object and manipulate a query rather than have a language do the querying for you. read more...

add a comment |category: Open Source |Views: 23

tags: SubSonic Query LINQ OpenSource SQL another

SubSonic: New Query Engine In The Works(blog.wekeroad.com)

submitted by gavinjoyce(25.7k) 4 years, 7 months ago

"Currently our Query tool is very useful, but it's sort of disconnected from the rest of the SubSonic Data tools. We're going to change all that with this next rev, and our goal is that you can intuitively work with the new Query tool as an extension of your object model if you like, or as a standalone querier." read more...

add a comment |category: Open Source |Views: 10

tags: RobConery Query SubSonic Database OpenSource another

Strongly Typed Stored Procedures Using Subsonic(haacked.com)

submitted by siphilp(867) 4 years, 8 months ago

In general, Subsonic is most productive when combining its code generation with its dynamic query engine and Active Record. But sometimes, your stuck with Stored Procedures and want to make the best of it. Subsonic, via the sonic.exe command line tool, can generate strongly typed stored procedure wrappers saving you from writing a lot of boilerplate code. read more...

add a comment |category: ADO.NET |Views: 98

tags: Query SubSonic ADO.NET another

SubSonic: Query Webcast Is Up(blog.wekeroad.com)

submitted by Anastasiosyal(960) 4 years, 9 months ago

A 20 minute webcast that talks about the enhancements to the Query Tool. read more...

add a comment |category: Open Source |Views: 60

tags: Query SubSonic another

Query and join tables across db server instances(principiaprogramatica.com)

submitted by gmiller(95) 5 years, 1 month ago

Sometimes you need to query across servers, even servers of different type such as doing a table join from MySQL to Oracle. I’m going to show you two ways you could do this if you have access to an SQL Server. There are ways to do this with other servers, and there are more than two ways to do this in SQL Server, but I’m only covering two methods both using SQL Server here. read more...

add a comment |category: ADO.NET |Views: 256

tags: SQL Join Query ADO.NET Database another