[How Do I:] LINQ to SQL: Data Model

Why are there no separate links for vb and c# code like in other videos?

i WOULD LIKE TO HAVE DEMO ON SILVERLIGHT?

WHAT IS SILVERLIGH?

fOR WHAT PURPOSE SILVERLIGTH IS USED?

KINDLY HELP ME TO KNOW MORE ABOUT SILVERLIGHT

REGARDS

jAGDISH

Silverlight is Microsoft's version of Flash. I believe their in Beta's now so just grab a versiona and play.

@mcp111

All videos in this catergory are C#. See VB Linq videos for vb code.

For those wondering where is the VB code... this video needs no code, this section is for both VB and C#

zmb94 : On May 02, 2008 6:29 PM said:

@mcp111

All videos in this catergory are C#. See VB Linq videos for vb code.

This is the worst programming design I have ever seen in my entire life. So now instead of just knowning SQL (a STANDARD which microsoft obviously knows nothing about) you have to learn LINQ to get any support on how to use Microsoft libraries, and on top of that I have to create one of these map files to generate the classes to use this new and asinine way of doing SQL queries to programs? What if I want to make changes to my database design? I have to recreate this map everytime to reflect it? That is just a plain out poor design. It took me two days to learn how to use SQL this way and I have been doing SQL extensivly with Oracle Databases and MySQL databases for the past two years. It took me two hours tops to learn how to use queries in programing languages such as Java with Oracle or MySQL. Microsoft is lucky the job I am working at now needs to use this to keep to standards for our customers, but when I am developing in my own time or for freelance, I will never use this piece of junk.

And another thing: SQL was made for the purpose of separating PROGRAMMING DATA from it's language, this is completely counter-productive to the whole mission of keeping data EXTERNAL to programming languages. Will I be able to use LINQ through PHP to get data out of a Microsoft SQL Express database? NO. PIECE OF JUNK.

@Dantevios -

Good to hear you're having good luck with writing SQL queries.

First off - Transact SQL implements the ANSI-92 SQL standard with server specific extensions.

Second - nobody said you were forced to use LINQ. At the very worst, you can create standard stored procedures (which is an acceptable way of separating PROGRAMMING DATA from your data access code). Or, you can use standard ADO.NET data access if you're convinced that going the long way is best.

Third - this is a .NET framework specific technology, and until we have an implementation of PHP.NET that implements framework 3.0 (which there might be already, who knows) you wouldn't be able to, nor want to use LINQ to SQL.

@Rwsmart

"First off - Transact SQL implements the ANSI-92 SQL standard with server specific extensions."

Transact SQL standards have absolutely nothing to do with this horrible piece of junk called LINQ. Microsoft stuck to that standard sure, but my point still remains: I have to learn LINQ to be able to use the SQL I already know, which is pointless!

"Second - nobody said you were forced to use LINQ. At the very worst, you can create standard stored procedures (which is an acceptable way of separating PROGRAMMING DATA from your data access code). Or, you can use standard ADO.NET data access if you're convinced that going the long way is best."

It's not my fault Microsoft's libraries for accessing data make it hard for you to program. This is my point. Other languages have libraries that easily allow you to interact with SQL by submitting your query strings to their pre-built objects. And also that you cannot find good examples on how to do this in ADO.NET because there are no good examples on the MSDN. This is probably an intential move to get people to use LINQ.

"Third...[...]"

ASP.NET makes it easy to build a lot of things that would take a very long time to make in javascript (especially AJAX) or with regular page to page web development functionality. For that I love it and it is worth paying the money to use the tools. But I still stand with my argument that LINQ is a piece of junk and I do not want to see anything like this ever again replicated for any of the other development tools I use.

@Dantevios

You're speaking out of ignorance. LINQ is far from pointless. It has as much, if not more, value as other ORM frameworks, especially in the business layer. It's not about "passing SQL statements". LINQ goes far beyond that. You're leaping to conclusions without understanding the technology, and simply foot-stamping rather than seriously evaluating a new technology. Your objections boil down to "It's not like a PHP library, and I have to learn something new, therefore it's useless".

Curl up witha good LINQ book, and after you know what you're talking about, if you decide to not use LINQ, then... don't use it. No one has a gun to your head.

Thanks for the video

thanks for the video,

@Dantevios:

I'm a Python programmer and a Linux user by nature. I've used both MySQL and PostgreSQL. I'm very familiar with various web-frameworks for Python. I've used the Apache and Lighttpd web servers.

Given that, I use C#.net at work. And frankly, I'm impressed with LINQ. I can't wait to use it in production. It's not a piece of junk. Many Open Source frameworks have their own ORMs. I find my projects easier and more manageable with tools like LINQ to SQL.

LINQ is turning out better than I initially expected. Given that you're still on video 2 on this tutorial that's aimed only towards the LINQ to SQL portion of the entire LINQ technology, I'd suggest doing more research on LINQ before spouting out your disapproval where people are trying to learn more about it.

Happy LINQing!

thanks.....

Mr.Dantevios. I've been using Microsoft technologies for the past 7-8 years and i'm happy with that. I make my living developing with Microsoft products. When i looked at LINQ to SQL i too had more or less the same reaction but the thing is, after seeing all these videos i came to conclusion that by using LINQ i could start doing more with less!!! and that's great! I think you´re a Open Source radical and the world knows all about radicals in other areas!

@Daventios

It sounds like Dantevios has never heard of the "System.Data.SqlClient" namespace.

You don't have to learn Linq to use SQL, Linq is new, how do you think we were building data access layers before Linq?

ADO.Net a conspiracy to move people to Linq? are you aware of how ADO.Net predates Linq by far?

"..It's not my fault Microsoft's libraries for accessing data make it hard for you to program"

Are you kidding? this is one of the easiest things to do in .Net. Those pre-built objects you talked about... we have them. Get a SqlConnection object, a SqlCommand object and bam! you just ran a query.

Pretty much all of your statements are misguided. Don't criticize things you don't understand.

thanks for the video

You Rock! Great Video Tutorial!

Thanks !Jërëjëf!

tHaNks :))

great video tutorial...

Thank you!

Great tutorial ..

I have a question.. I created  the dbml by dragging two table from the server explorer.. but i gave my code to some one and if he need to change the connection string ..where does he need to change?

I learned that none of the linq assemblies work when the project is started in IIs mode verses file mode.  In iis mode on my development machine the database would give select permissions to my link object.  Hope this helps someone out there.

Hi PinFeather4200,

One of the way is:

LinqMPLMDataContext.Connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

But make sure you do this as you instantiate each datacontext. There are other ways out there.

I like LINQ compared to nHibernate. It was 3 yrs ago when I played. I still remember when we have to hard code the mapping files. Now its drag and drop. It is still a pain when I have to refresh the dbml file, I have to delete and drag and drop again. There must be a better way and I have not discovered it yet.

But I'm sure nHibernate improved since then and there must be a plug-in already available that do the same job.

Nice.. Tutorial thanks

Thanks for the videos. These were great for getting up to speed on this technology.