Help me.. prob with desginer.cs

Oshrib · March 20th, 2011, 03:34 AM

Hello

First of all i must say that the book is g-r-e-a-t !!!

i built site that very similar to the final project of PlanetWrox from the book. on my localhost the site works great ! but i uploaded the site to GoDaddy, i made the sql file and uploaded it at GoDaddy on the query analyzer.

i have problem at this page:

http://grafiko.co.il/index2.aspx

( Server Error in '/' Application.

Line 41: #endregion
Line 42:
Line 43: public GrafikoDataContext() :
Line 44: base(global::System.Configuration.ConfigurationMan ager.ConnectionStrings["GrafikoDataContextConnectionString1"].ConnectionString, mappingSource)
Line 45: {

Source File: d(....)\App_Code\Grafiko.designer.cs Line: 43

again, at my localhost that works great.

that how start my desginer.cs file:::::
--------------------------------

#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
// This code was generated by a tool.
// Runtime Version:4.0.30319.1
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;

[global::System.Data.Linq.Mapping.DatabaseAttribute (Name="Grafiko")]
public partial class GrafikoDataContext: System.Data.Linq.DataContext

----------------------------

i really don't know what to do... i need to do somthing with the .dbml at godaddy?

i uploaded the app_code directory and i gave the premmisions to modify.

mmmm i don't know what to do, help me. thanks :)

Imar · March 20th, 2011, 07:54 AM

Hi there,

Does your web.config contain a connection string called GrafikoDataContextDataContextConnectionString1 that points to the database you're using for your Linq to Sql classes?

Imar

Oshrib · March 20th, 2011, 09:37 AM

Hi !
thanks for you reply.

that's my web.config connection stirng:

- <connectionStrings>
<clear />
<add name="GrafikoConnectionString1" connectionString="Data Source=whsql-v04.(******).net;Initial Catalog=grafiko;User Id=******; Password=*******;" providerName="System.Data.SqlClient" />
</connectionStrings>

Imar · March 20th, 2011, 09:44 AM

But not one called GrafikoDataContextDataContextConnectionString1 , right? That's what the error message seems to suggest.....

Oshrib · March 20th, 2011, 09:50 AM

Quote:

Originally Posted by Imar

But not one called GrafikoDataContextDataContextConnectionString1 , right? That's what the error message seems to suggest.....

so i need to write the string like that? :

<add name="GrafikoDataContextDataContextConnectionStrin g1" connectionString="Data Source=whsql-v04.(******).net;Initial Catalog=grafiko;User Id=******; Password=*******;" providerName="System.Data.SqlClient" />

Imar · March 20th, 2011, 09:54 AM

Yes, try that and see if it helps....

Imar

Oshrib · March 20th, 2011, 09:54 AM

Quote:

Originally Posted by Oshrib

so i need to write the string like that? :

<add name="GrafikoDataContextDataContextConnectionStrin g1" connectionString="Data Source=whsql-v04.(******).net;Initial Catalog=grafiko;User Id=******; Password=*******;" providerName="System.Data.SqlClient" />

i have changed that, and now i have a new error:

Invalid keyword, contain one or more of 'no characters', 'control characters', 'leading or trailing whitespace' or 'leading semicolons'.
Parameter name: data
source

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Invalid keyword, contain one or more of 'no characters', 'control characters', 'leading or trailing whitespace' or 'leading semicolons'.
Parameter name: data
source

Source Error:

Line 41: #endregion
Line 42:
Line 43: public GrafikoDataContext() :
Line 44: base(global::System.Configuration.ConfigurationMan ager.ConnectionStrings["GrafikoDataContextConnectionString1"].ConnectionString, mappingSource)
Line 45: {

Source File: d:\hosting\7540143\html\App_Code\Grafiko.designer. cs Line: 43

Oshrib · March 20th, 2011, 09:58 AM

Imar, that's possible that LINQ is not an options at GODaddy ?

againg, i don't know how to upload the .dbml file, if that's ok to upload only the app_code dir so i made that. but if i need to do schema or somthing like that, that's a problem.

Imar · March 20th, 2011, 10:09 AM

Quote:

Exception Details: System.ArgumentException: Invalid keyword, contain one or more of 'no characters', 'control characters', 'leading or trailing whitespace' or 'leading semicolons'.

This seems to suggest you have invalid data in your connection string such as line breaks.

Quote:

Imar, that's possible that LINQ is not an options at GODaddy ?

I don't know; you'll need to ask them.

Quote:

againg, i don't know how to upload the .dbml file, if that's ok to upload only the app_code dir so i made that

Yes, you should be able to upload your site as-is including stuff in the App_Code folder.

Quote:

but if i need to do schema or somthing like that, that's a problem.

L2S doesn't create the database for you, so you somehow need to create your database first at the target server. Chapter 18 shows you how to do this, but for specific details you need to talk to GoDaddy....

CHope this helps,

Imar

Oshrib · March 20th, 2011, 11:46 AM

Imar !!!

that's work !! :)

i have played with the connection string, and i found at the database manager of GoDaddy button "configuration" ... and there was the specific SqlConnection (.NET) string....

thank you !
if someone stack with godaddy at the database side - you can ask me.