| Panel |
|---|
| panelIconId | 1f51c |
|---|
| panelIcon | :soon: |
|---|
| panelIconText | 🔜 |
|---|
| bgColor | #EAE6FF |
|---|
|
Dieses Feature ist in der nächsten primedocs Version verfügbar. |
...
Mit dem SqlDataProvider können Sie auf beliebig konfigurierbare SQL-Datenbanken zugreifen.
...
| Code Block |
|---|
|
SELECT STRING(FirstName, ' ', MiddleName) AS CompleteName, LastName FROM Users
WHERE CompleteName LIKE '%' + ? + '%' |
Beispiel-XML-Konfiguration
| Code Block |
|---|
|
<SqlDataProvider DisplayName="Datenbank">
<SearchParameters>
<Text Id="Name" Label="Name" />
</SearchParameters>
<Options>
<ConnectionString>Data Source=localhost;Initial Catalog=Customers;User Id={user};Password={pwd};</ConnectionString>
<ConnectionProvider>System.Data.SqlClient</ConnectionProvider>
<Query>
SELECT * FROM Customers WHERE Name Like '%' + @Name + '%'
</Query>
</Option>Options>
<Mapping>
<Map Source="Name" Target="CompanyName" />
<Map Source="Street" Target="Street" />
<Map Source="Zip" Target="PostalCode" />
<Map Source="City" Target="City" />
<Map SourceValue="CH" Target="Country" />
</Mapping>
</SqlDataProvider> |