jel mmi može netko pomoći oko generiranja cs file-a za C# za linq.
koristim dblinq
http://code.google.com/p/dblinq2007/downloads/list
a baza je mysql.
za generiranje koristim DbMetal
.bat file
DBMetal.exe -provider=MySql -database:northwind -server:localhost -user:root -password:123 -port=3307 -namespace:WindowsFormsApplication1 -code:nw.cs
nw.dbml file
Code:
<?xml version="1.0" encoding="utf-8"?>
<Database Class="DataClasses1DataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
<Table Name="" Member="categories">
<Type Name="categories">
<Column Name="CategoryID" Type="System.String" CanBeNull="false" />
<Column Member="Picture" Type="System.String" CanBeNull="false" />
</Type>
</Table>
</Database>
nw.cs
Code:
#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
// This code was generated by a tool.
// Runtime Version:2.0.50727.4927
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
namespace WindowsFormsApplication1
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
public partial class DataClasses1DataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
#endregion
public DataClasses1DataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table<categories> categories
{
get
{
return this.GetTable<categories>();
}
}
}
[Table(Name="")]
public partial class categories
{
private string _CategoryID;
private string _Picture;
public categories()
{
}
[Column(Storage="_CategoryID", CanBeNull=false)]
public string CategoryID
{
get
{
return this._CategoryID;
}
set
{
if ((this._CategoryID != value))
{
this._CategoryID = value;
}
}
}
[Column(Storage="_Picture", CanBeNull=false)]
public string Picture
{
get
{
return this._Picture;
}
set
{
if ((this._Picture != value))
{
this._Picture = value;
}
}
}
}
}
#pragma warning restore 1591
u cmd probam izvršit
C:\DbMetal a.bat
ali dobijem hrpu grešaka.
s time da je dbml file ručno kreiran, schema nije povučena iz baze, a niti se nisam mogao spojiti na bazu tj. s Linq to sql se ne može koristiti sluzbeni konektor za mysql.
Code:
C:\Users\marko\Desktop\DbLinq-0.19\DbLinq-0.19>DbMetal a.bat
DbLinq Database mapping generator 2008 version 0.19
for Microsoft (R) .NET Framework version 3.5
Distributed under the MIT licence (http://linq.to/db/license)
>>> Reading schema from DBML file 'a.bat'
DbMetal failed:System.InvalidOperationException: There is an error in XML docume
nt (3, 1). ---> System.Xml.XmlException: Data at the root level is invalid. Line
3, position 1.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XsdValidatingReader.Read()
at System.Xml.XmlReader.MoveToContent()
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderDataba
se.Read24_Database()
--- End of inner exception stack trace ---
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, St
ring encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader)
at DbLinq.Schema.Dbml.DbmlSerializer.Read(Stream xmlStream, IList`1 validatio
nErrors) in Z:\Development\DbLinq-0.19\src\DbLinq\Schema\Dbml\DbmlSerializer.cs:
line 102
at DbLinq.Schema.Dbml.DbmlSerializer.Read(Stream xmlStream) in Z:\Development
\DbLinq-0.19\src\DbLinq\Schema\Dbml\DbmlSerializer.cs:line 116
at DbMetal.Generator.Implementation.Processor.ReadSchema(Parameters parameter
s, String filename) in Z:\Development\DbLinq-0.19\src\DbMetal\Generator\Implemen
tation\Processor.cs:line 247
at DbMetal.Generator.Implementation.Processor.ReadSchema(Parameters parameter
s, ISchemaLoader& schemaLoader) in Z:\Development\DbLinq-0.19\src\DbMetal\Genera
tor\Implementation\Processor.cs:line 216
at DbMetal.Generator.Implementation.Processor.ProcessSchema(Parameters parame
ters) in Z:\Development\DbLinq-0.19\src\DbMetal\Generator\Implementation\Process
or.cs:line 116
C:\Users\marko\Desktop\DbLinq-0.19\DbLinq-0.19>
javlja mi grešku za xml, a dbml generiran iz visual studija.
visual studio je 2008 sp1